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

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql
Дата
Msg-id CAKAnmmLqWPJcDiLXkrkjOUDHV6kBHpVT+oeFcAFc874XMhgKNg@mail.gmail.com
обсуждение исходный текст
Ответ на [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql  (Srinath Reddy <srinath2133@gmail.com>)
Ответы Re: [Proposal] Add \dAt [AMPTRN [TBLPTRN]] to list tables by Table Access Method in psql
Список 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 по дате отправления: