Re: Switching databases over JDBC/ODBC

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Switching databases over JDBC/ODBC
Date: 2009-05-30 06:31:51
Message-ID: 4A20D2D7.6060501@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Bailey 2009-05-30 07:46:33 Re: Switching databases over JDBC/ODBC
Previous Message Kris Jurka 2009-05-30 05:22:45 Re: Pl/java in 8.4 bet1 sources compilation failed