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

Works perfect. I'll trap and show only our databases to the user.
all thanks
On Wed, 2012-03-07 at 21:00 +0100, Szymon Guz wrote:
> 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