Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group