Postgres Pro
Downloads
Home   >   mailing lists

Thread: Changing a database

Changing a database

From
Amarsh M
Date:
Hi all,
 
I was wondering if there was a way to change the database in PostGresql using ODBC, kinda like the \c command on the psql prompt. I tried many changes but none work. Any ideas ? should be a pure SQL statement I guess.
 
Thanks in advance
A

Re: Changing a database

From
"Dave Page"
Date:
 

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Amarsh M
Sent: 21 September 2005 02:56
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Changing a database

Hi all,
 
I was wondering if there was a way to change the database in PostGresql using ODBC, kinda like the \c command on the psql prompt. I tried many changes but none work. Any ideas ? should be a pure SQL statement I guess.
 
No, this is not possible. You need to open an new connection.
 
Regards, Dave.