Re: Programatically switching database - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Programatically switching database
Date
Msg-id Pine.LNX.4.44.0311151735470.5327-100000@peter.localdomain
Whole thread Raw
In response to Re: Programatically switching database  (ow <oneway_111@yahoo.com>)
Responses Re: Programatically switching database  (ow <oneway_111@yahoo.com>)
Re: Programatically switching database  (ow <oneway_111@yahoo.com>)
List pgsql-sql
ow writes:

> 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).

I'm afraid that what you want to do is not possible.  Perhaps you want to
organize your data into schemas, not databases.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-sql by date:

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