Обсуждение: Changing a database

Поиск
Список
Период
Сортировка

Changing a database

От
Amarsh M
Дата:
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

От
"Dave Page"
Дата:
 

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.