[Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql - Mailing list pgsql-hackers

From Srinath Reddy
Subject [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql
Date
Msg-id CAFC+b6pD1tFY3qCf9S4VV919LK4_t33U7tCjfNqFVGu55GxMgA@mail.gmail.com
Whole thread Raw
Responses Re: [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql
Re: [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql
List pgsql-hackers
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/

pgsql-hackers by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: Conflict detection for update_deleted in logical replication
Next
From: Yura Sokolov
Date:
Subject: Re: Built-in Raft replication