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@xxxxxxxxxxxxxxxxxxxxx> > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
