Hi,
you can only run inquires now on information_schema for the database you
are connected to.
If you are looking/searching in pg_database though, you can information
globally.
Something changed recently (I am using Dbeaver); I was able to attach to
a single database and see all my
On 10/15/22 08:56, Igor Korot wrote:
Hi, Adrian,
So any and all operations/queries performed before, during or after that
will be done on (finance) catalog), because this is the "main"
connection, right?
I think you are getting stuck on SQLite terminology:
Hi, Adrian,
On Sat, Oct 15, 2022, 10:51 AM Adrian Klaver
wrote:
> On 10/15/22 08:20, Adrian Klaver wrote:
> > On 10/14/22 21:46, Igor Korot wrote:
> >
> >
> >> Making catalog current means switching between DBs.
> >> Remember initially I connected to (finance) DB, which made the
> >>
On 10/15/22 08:20, Adrian Klaver wrote:
On 10/14/22 21:46, Igor Korot wrote:
Making catalog current means switching between DBs.
Remember initially I connected to (finance) DB, which made the
(finance) catalog
current.
Then I "opened a second connection" to (finance_2021), which made
that
On 10/14/22 21:46, Igor Korot wrote:
Making catalog current means switching between DBs.
Remember initially I connected to (finance) DB, which made the (finance) catalog
current.
Then I "opened a second connection" to (finance_2021), which made
that current catalog and so that select would
Hi,
On Fri, Oct 14, 2022 at 11:16:44PM -0500, Igor Korot wrote:
>
> Sorry for resurrecting this old thread...
> If an attaching the DB creates new connection which will be cmpletely
> independent - how the INFORMATION_SCHEMA.table@table_catalog
> field is handled.
>
> Lets say I open connection