Re: Get table catalog from pg_indexes

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Get table catalog from pg_indexes
Дата
Msg-id CAKFQuwaO3gauZGVpkAipq59bX0MvpAXRx-ts-iOd7R_+2jV9tg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Get table catalog from pg_indexes  (Igor Korot <ikorot01@gmail.com>)
Ответы Re: Get table catalog from pg_indexes  (Igor Korot <ikorot01@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Sun, Nov 27, 2022 at 11:42 AM Igor Korot <ikorot01@gmail.com> wrote:

It doesn't say anything about "current" DB - only the DB.

Yes, but you must be connected to some database in order to execute this command: "the database" refers to this database you are connected to.

The catalogs are not information_schema.


However, I think I can try "SELECT 1 FROM <catalog>.pg_indexes...".
Will this work?


What is that even supposed to mean?  It also seems simple enough to just do that asking "will this work" is a waste of time.  Just try it.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Igor Korot
Дата:
Сообщение: Re: Get table catalog from pg_indexes
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Get table catalog from pg_indexes