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 databas
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:
https://sqlite.org/lang_attac
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
> >> (finance)
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 cu
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 give
