Re: switching db's on the fly - Mailing list pgsql-jdbc

From Bruce Momjian
Subject Re: switching db's on the fly
Date
Msg-id 200207031623.g63GNHg13820@candle.pha.pa.us
Whole thread Raw
In response to switching db's on the fly  (Toby Doig <toby@paperjet.com>)
List pgsql-jdbc
Toby Doig wrote:
> after connecting to a db under pg 7.2.x using the url, is it possible to
> switch to another db hosted on the same machine without reconnecting?
>
> i have a setup with several databases all hosted on the same server with
> the same db owner etc. i've written my own pooling but then i need to pool
> for each db which, given the number of db's, means i end up with a lot of
> idle connections using resources.
>
> what would be better is to be able to switch to the appropriate db
> when the connection is retrieved from the pool. this then pools
> connections between db's as well. i understand there's some mgmt involved
> with access to the db on a switch, but i believe this is easily managed.
>
> under mssql server you can use the USE <database> command.
> Is there some equivalent or some hack possible?

No, sorry, you have to reconnect. psql has a \connect, but it just
reconnects too.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with sql function LOWER
Next
From: Toby Doig
Date:
Subject: Re: Servlet uplad with Multipart and LO