Thread: current database?

current database?

From
mikeo
Date:
hi,
 when i do \c - postgres tells me which
database i'm currently connected to.  where
does it get this info?  i'd like to use it
in a program.

TIA,
  mikeo

Re: current database?

From
Peter Eisentraut
Date:
mikeo writes:

>  when i do \c - postgres tells me which
> database i'm currently connected to.  where
> does it get this info?  i'd like to use it
> in a program.

It remembers this information from when you first connected, e.g., `psql
-d template1'.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Re: current database?

From
Tom Lane
Date:
mikeo <mikeo@spectrumtelecorp.com> writes:
>  when i do \c - postgres tells me which
> database i'm currently connected to.  where
> does it get this info?  i'd like to use it
> in a program.

If you're working directly with libpq, then PQdb() et al return
the connection parameters used to create the current PGconn object.

            regards, tom lane