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

From Srinath Reddy
Subject Re: [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql
Date
Msg-id CAFC+b6pk-HoRkPbCUy6OTenJ1wV0aMqayXMhp7woLc7-s_fpgg@mail.gmail.com
Whole thread Raw
In response to Re: [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql  (Mahendra Singh Thalor <mahi6run@gmail.com>)
List pgsql-hackers
Hi,

On Tue, Apr 15, 2025 at 3:22 PM Mahendra Singh Thalor <mahi6run@gmail.com> wrote:

I think we can get both the details by SELECT command.
 
Thanks for the input!
While it's true that we can use catalog queries to get this info, the main goal of adding a \dAt command or "\"[Informational] commands is to improve user experience and discoverability. Not everyone wants to write or remember complex queries — having a direct command helps users quickly inspect TAM usage, especially when working with multiple forks or extensions.

Additionally,
this info should be visible by the admin only because there is no use
case for the user to know all the tables from one TAM.
 
I don’t think this information should be restricted to admins. When specialized TAMs are in use, it’s actually valuable for users to know which TAM a table is using. This helps them understand how best to interact with the table and structure their workloads to align with the TAM's intended access patterns.

Thanks,
Srinath Reddy Sadipiralla
EDB: https://www.enterprisedb.com/

pgsql-hackers by date:

Previous
From: Ranier Vilela
Date:
Subject: Silence using uninitialized value
Next
From: Peter Eisentraut
Date:
Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER