Programatically switching database - Mailing list pgsql-sql

From ow
Subject Programatically switching database
Date
Msg-id 20031115043616.90388.qmail@web21405.mail.yahoo.com
Whole thread Raw
Responses Re: Programatically switching database  (Peter Eisentraut <peter_e@gmx.net>)
Re: Programatically switching database  (ow <oneway_111@yahoo.com>)
List pgsql-sql
Hi,

Suppose pgSql server is running databases "db1" and "db2" that are in the same
db cluster. A client app establishes connection "conn1" to db1. Is there a way
to programatically switch conn1 to use db2 without doing
disconnect-from-db1-connect-to-db2? Something like what "\c" does but to be
used independently from psql? I need this to be able to reuse a pool of
connections to db1 for actions on db1, db2 ... dbn.

Thanks






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


pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Need Help
Next
From: Peter Eisentraut
Date:
Subject: Re: Programatically switching database