Postgres Pro
Downloads
Home   >   mailing lists

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

From Igor Korot
Subject Re: Get table catalog from pg_indexes
Date
Msg-id CA+FnnTz7pQgJJOFN27muDKN3zauJEj=gtYUSYqkrV-cB-GsfqQ@mail.gmail.com
Whole thread Raw
In response to Re: Get table catalog from pg_indexes  (Christophe Pettus <xof@thebuild.com>)
Responses Re: Get table catalog from pg_indexes  (Christophe Pettus <xof@thebuild.com>)
Re: Get table catalog from pg_indexes  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

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