Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Switching database inside current connection
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Jeff Madison <jeff(at)madisonfam(dot)net>
- Cc: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: Switching database inside current connection
- Date: Wed, 27 Sep 2006 23:27:57 -0500 (EST)
On Wed, 27 Sep 2006, Jeff Madison wrote:
I have to search multiple, identical databases on a server and am currently having to create a DataSource for each database on the server and then get a connection. How would I create a DataSource for the server and then modify the connnection to "switch" databases. I would like to just re-use the same connection for obvious reasons.
This is not possible with postgresql. You can only use the database you initially connected to. To access parts of other database you can use contrib/dblink, but for your purposes I think multiple connections are required.
Kris Jurka
- References:
- Switching database inside current connection
- From: Jeff Madison
- Switching database inside current connection
- Prev by Date: Switching database inside current connection
- Next by Date: Re: [pgsql-jdbc] dollar-quoted CREATE FUNCTION statement fails
- Previous by thread: Switching database inside current connection
- Next by thread: Re: Switching database inside current connection
- Indexes: