Re: Switching databases over JDBC/ODBC - Mailing list pgsql-general

From John R Pierce
Subject Re: Switching databases over JDBC/ODBC
Date
Msg-id 4A20D2D7.6060501@hogranch.com
Whole thread Raw
In response to Re: Switching databases over JDBC/ODBC  (Scott Bailey <artacus@comcast.net>)
Responses Re: Switching databases over JDBC/ODBC
List pgsql-general
Scott Bailey wrote:
> Well at work we've got Oracle, MySQL, MS SQL and Postgres. So I
> generally use Aqua Data Studio because it works with all of them. For
> MySQL and MS SQL you register a single connection to the server and
> can switch to any database. But with Postgres, you have to register a
> new connection for every database because you can't switch once
> connected.
>
> I just figured that if even Microsoft can do it, surely we can.


you could always use SCHEMA instead of DATABASE if thats what you want.

btw, in Oracle, you need a different connection for different database
instances, too.



pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Pl/java in 8.4 bet1 sources compilation failed
Next
From: Scott Bailey
Date:
Subject: Re: Switching databases over JDBC/ODBC