Programatically switching database

From: ow <oneway_111(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Programatically switching database
Date: 2003-11-15 04:36:16
Message-ID: 20031115043616.90388.qmail@web21405.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2003-11-15 10:11:47 Re: Programatically switching database
Previous Message Jim Drummey 2003-11-14 17:02:48 Substrings by Regular Expression