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.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general