Re: Get table catalog from pg_indexes

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Get table catalog from pg_indexes
Дата
Msg-id EE47A411-5C56-4C31-BB31-70B11EA47071@thebuild.com
обсуждение исходный текст
Ответ на Re: Get table catalog from pg_indexes  (Igor Korot <ikorot01@gmail.com>)
Список pgsql-general

> On Nov 27, 2022, at 10:53, Igor Korot <ikorot01@gmail.com> wrote:
> Are you saying I can't run any query on other DB? Or connect to DB and
> run select?

The query you run only looks at the system catalogs for the database you are connected to (with the exception of the
smallnumber of global catalogs, like pg_database).  So, if you are connected to database "a", you can't query the
systemcatalogs of database "b" for what indexes are in them. 


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Get table catalog from pg_indexes
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Get table catalog from pg_indexes