change database - Mailing list pgsql-general

From Florian Chis
Subject change database
Date
Msg-id 32f81f010907150136v424672a4m2db78b98fac13482@mail.gmail.com
Whole thread Raw
Responses Re: change database
Re: change database
List pgsql-general
Hi,

I'm working on a port from mysql to postgres. I have a function which connect's to the database, checks for database existance and creates it otherwise.
The last thing it does it executes "use my_database" (mysql stuff). Now I'm trying to find something similar in postgres. I know that psql has \c but that dosen't help me with jdbc. I also know that the easy solution out of this is to close the connection and then open it again with /my_database in the URL but I want to avoid this.

So what are my options?

With thanks,
Florian

pgsql-general by date:

Previous
From: benoît carpentier
Date:
Subject: [ANNOUNCE] Benetl, a free ETL tool for files using postgreSQL, is out in version 2.9
Next
From: John R Pierce
Date:
Subject: savepoints in 8.3.7 or whatever...