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

From: Srinath Reddy <srinath2133(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql
Date: 2025-04-15 08:56:51
Message-ID: CAFC+b6pD1tFY3qCf9S4VV919LK4_t33U7tCjfNqFVGu55GxMgA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Yura Sokolov 2025-04-15 08:57:24 Re: Built-in Raft replication
Previous Message Hayato Kuroda (Fujitsu) 2025-04-15 08:52:03 RE: Conflict detection for update_deleted in logical replication