Re: Switching databases over JDBC/ODBC

From: "Bayless Kirtley" <bkirt(at)cox(dot)net>
To: "Scott Bailey" <artacus(at)comcast(dot)net>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Switching databases over JDBC/ODBC
Date: 2009-05-29 23:43:22
Message-ID: 8268CC4FB4AD4D89B0A1F4EFEF025246@dell2400
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You can establish a new connection without dropping the old one. Thus you
can be connected to 2 databases at the same time. Just use the appropriate
connection for the database you want.

Bayless

----- Original Message -----
From: "Scott Bailey" <artacus(at)comcast(dot)net>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, May 29, 2009 6:34 PM
Subject: [GENERAL] Switching databases over JDBC/ODBC

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin Gainty 2009-05-29 23:53:28 Re: Switching databases over JDBC/ODBC
Previous Message Scott Bailey 2009-05-29 23:34:31 Switching databases over JDBC/ODBC