Show Databases via ODBC

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

Works perfect. I'll trap and show only our databases to the user.
all thanks