Re: libpq analog of \c

On 10/5/26 7:57 AM, Igor Korot wrote:
> Hi,
>
>
>
> On Sun, Oct 4, 2026, 11:35 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at
> <mailto:laurenz(dot)albe(at)cybertec(dot)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(dot)klaver(at)aklaver(dot)com