Re: Show Databases via ODBC

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(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