Re: Programatically switching database - Mailing list pgsql-sql

From ow
Subject Re: Programatically switching database
Date
Msg-id 20031115160036.4919.qmail@web21409.mail.yahoo.com
Whole thread Raw
In response to Programatically switching database  (ow <oneway_111@yahoo.com>)
Responses Re: Programatically switching database  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
---  Peter Eisentraut wrote:
> Nothing prevents you from keeping the connection to db1 open when you open
> a connection to db2.  By the way, psql's "\c" command does exactly
> disconnect-from-db1-connect-to-db2.

That's the whole point: I'm trying to avoid maintaining *separate* connection
pools for each db. In other words, instead of having, say, 5 connection pools
to 5 dbs with total of 1000 connections, I could've used just one (1) pool with
200 connections, if there was a way to "switch db" (or to do a cross-db query).

Any ideas? Thanks






__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree


pgsql-sql by date:

Previous
From: Guillaume LELARGE
Date:
Subject: Re: Getting last insert value
Next
From: Peter Eisentraut
Date:
Subject: Re: Programatically switching database