Re: Switching databases over JDBC/ODBC

Scott Bailey wrote:
> Is there an equivalent to psql's \connect database or MySQL/MS SQL's use
> database command that will work with JDBC? It doesn't seem like I should
> need to drop the connection and establish a new one just to switch
> databases.


the \connect command disconnects from the current database, and connects
to a new one, this causes a new postgres server process to be spawned to
replace the one servicing the old connection.