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

From Greg Sabino Mullane
Subject Re: [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql
Date
Msg-id CAKAnmmLqWPJcDiLXkrkjOUDHV6kBHpVT+oeFcAFc874XMhgKNg@mail.gmail.com
Whole thread Raw
In response to [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql  (Srinath Reddy <srinath2133@gmail.com>)
Responses Re: [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql
List pgsql-hackers
On Tue, Apr 15, 2025 at 4:57 AM Srinath Reddy <srinath2133@gmail.com> wrote:
- Table Access Methods are increasingly used.

Citation needed.
 
- There's currently no native `\d`-style way to explore which tables are using a given TAM.

There's also no way to list which tables are unlogged. Or which have autovacuum disabled. Or which belong to a specific tablespace. All of which are arguably more commonly requested than a TAM.

Perhaps there could be a more generic table-filtering mechanism for \d, but carving something out for such a niche case seems unwarranted, IMO.

Downstream, you wrote:
Not everyone wants to write or remember complex queries

True - but you can write a view or a function to support those cases.


Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: FmgrInfo allocation patterns (and PL handling as staged programming)
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Built-in Raft replication