current database?

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

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