Re: Get table catalog from pg_indexes - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Get table catalog from pg_indexes
Date
Msg-id EE47A411-5C56-4C31-BB31-70B11EA47071@thebuild.com
Whole thread Raw
In response to Re: Get table catalog from pg_indexes  (Igor Korot <ikorot01@gmail.com>)
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Get table catalog from pg_indexes
Next
From: Adrian Klaver
Date:
Subject: Re: Get table catalog from pg_indexes