On 10/5/26 7:57 AM, Igor Korot wrote:
> Hi,
>
>
>
> On Sun, Oct 4, 2026, 11:35 PM Laurenz Albe <laurenz.albe@cybertec.at
> <mailto:laurenz.albe@cybertec.at>> wrote:
>
> On Sun, 2026-10-04 at 23:09 -0700, Igor Korot wrote:
> > What do issue in the libpq interface to
> > select the current database?
>
> You cannot select the current database. A database connection remains
> connected to the same database for the entire time of the connection.
> You'll have to do what psql does: connect to the second database, and
> if that succeeds, disconnect from the first one.
>
>
> Where do I look for that code?
https://github.com/postgres/postgres/blob/master/src/bin/psql/command.c
As a starting point, section beginning with:
/*
* \c or \connect -- connect to database using the specified parameters.
*
* \c [-reuse-previous=BOOL] dbname user host port
...
>
> Thank you.
>
>
> Yours,
> Laurenz Albe
>
--
Adrian Klaver
adrian.klaver@aklaver.com
