Re: Programatically switching database

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: ow <oneway_111(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Programatically switching database
Date: 2003-11-15 16:36:39
Message-ID: Pine.LNX.4.44.0311151735470.5327-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Guillaume LELARGE 2003-11-15 16:40:42 Re: Getting last insert value
Previous Message ow 2003-11-15 16:00:36 Re: Programatically switching database