Horton
Menu

Re: Get table catalog from pg_indexes

Igor Korot <ikorot01@gmail.com>

View thread
From: Igor Korot <ikorot01@gmail.com>
To: Christophe Pettus <xof@thebuild.com>
Cc: Erik Wienhold <ewie@ewie.name>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2022-11-27T18:53:18Z
Lists: pgsql-general 
Hi, Christopher,

On Sun, Nov 27, 2022 at 12:45 PM Christophe Pettus <xof@thebuild.com> wrote:
>
>
>
> > On Nov 27, 2022, at 10:42, Igor Korot <ikorot01@gmail.com> wrote:
> >
> > It doesn't say anything about "current" DB - only the DB.
>
> In PostgreSQL terminology, a single PostgreSQL instance (the cluster) can have multiple databases.

Just like any other DBMS.

> The database the connection is currently open to is the current database.

Are you saying I can't run any query on other DB? Or connect to DB and
run select?

Thank you.