Thread: list databases with SQL command

Hi,

maybe its a silly question, but is there a way to list all databases
with an SQL command? I know about the \l command from psql, but i
wonder if such things are possible with SQL.

regards, David

Am Dienstag, 18. Januar 2005 11:32 schrieb David Teran:
> maybe its a silly question, but is there a way to list all databases
> with an SQL command? I know about the \l command from psql, but i
> wonder if such things are possible with SQL.

SELECT * FROM pg_database;

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

David Teran wrote:
> Hi,
>
> maybe its a silly question, but is there a way to list all databases
> with an SQL command? I know about the \l command from psql, but i wonder
> if such things are possible with SQL.

Look into the pg_class table or the information schema.
Also, if you start psql with -E then you can see how it executes all its
  backslash commands.

--
   Richard Huxton
   Archonet Ltd