ow writes:
> Is there a way to programatically switch conn1 to use db2 without doing
> disconnect-from-db1-connect-to-db2? Something like what "\c" does but to
> be used independently from psql? I need this to be able to reuse a pool
> of connections to db1 for actions on db1, db2 ... dbn.
Nothing prevents you from keeping the connection to db1 open when you open
a connection to db2. By the way, psql's "\c" command does exactly
disconnect-from-db1-connect-to-db2.
--
Peter Eisentraut peter_e(at)gmx(dot)net