Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] get the list of databases - Mailing list pgsql-general

From Doran L. Barton
Subject Re: [GENERAL] get the list of databases
Date
Msg-id 19991005102411.A28097@iodynamics.com
Whole thread Raw
In response to get the list of databases  (Xavier COUDIN <xavier@nnc.fr>)
List pgsql-general
Tree view 
Not long ago, Xavier COUDIN proclaimed...
> using psql, it is possible to get the list of databases using the
> instruction  "\l".
>
> How can I do when I make connection through DBI/DBD ?????

Well you need to connect to *some* database (i.e. template1) and then you
can issue the following SQL query:

  SELECT * FROM PG_DATABASE;

Enjoy.

--
Doran L. Barton <fozz@iodynamics.com>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>

pgsql-general by date:

Previous
From: Xavier COUDIN
Date:
Subject: get the list of databases
Next
From: "Ing. Arturo de la Torre"
Date:
Subject: Some information about JDBC