On 7 March 2012 20:36, Bret Stern <bret_stern(at)machinemanagement(dot)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