Postgres Pro
Downloads
Home   >   mailing lists

Re: Show Databases via ODBC - Mailing list pgsql-general

From Szymon Guz
Subject Re: Show Databases via ODBC
Date
Msg-id CAFjNrYtZjrYOGD+GF4yeCpGMN8tLUYUdhO6-xqwOXaRq_7d9xg@mail.gmail.com
Whole thread Raw
In response to Show Databases via ODBC  (Bret Stern <bret_stern@machinemanagement.com>)
Responses Re: Show Databases via ODBC  (Bret Stern <bret_stern@machinemanagement.com>)
List pgsql-general
Tree view
On 7 March 2012 20:36, Bret Stern <bret_stern@machinemanagement.com> wrote:
Is it possible through ODBC to connect to a PostgreSql
server and query for the available databases?

When our application upgrades, we typically create a
new database. I want to design a form which allows
the user to select the old database, which then
migrates data to the new (currently connected)
database.

Regards



Hi,
I think this query would be helpful: 

  select datname from pg_database;

regards
Szymon

pgsql-general by date:

Previous
From: Bret Stern
Date:
Subject: Show Databases via ODBC
Next
From: John R Pierce
Date:
Subject: Re: Automated Backup Script Help (Linux)