Re: switching db's on the fly

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026