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