Hi all,
I'd like to propose adding a new `psql` meta-command:
\dAt [AMPTRN [TBLPTRN]]
This would list all user tables that are using a specific Table Access
Method (TAM), optionally filtered by table name pattern.
Why?
- Table Access Methods are increasingly used.
- There's currently no native `\d`-style way to explore which tables are
using a given TAM.
- Users often need to check or debug TAM-based extensions and it'd be
useful to have a shortcut.
Example usage:
\dAt sometam -- list all tables using sometam TAM
\dAt sometam auto% -- filter to tables starting with 'auto'
Would love to hear if this sounds like a useful addition — if so, I’d be
happy to work on a patch. Also, please let me know if something similar has
been discussed before.
Thanks,
Srinath Reddy Sadipiralla
EDB: https://www.enterprisedb.com/