Re: Switching databases over JDBC/ODBC

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.