Re: list databases with SQL command

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: David Teran <david(dot)teran(at)cluster9(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: list databases with SQL command
Date: 2005-01-18 11:13:52
Message-ID: 200501181213.53812.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-01-18 11:21:59 Re: list databases with SQL command
Previous Message Iavor Raytchev 2005-01-18 11:10:48 one or two tables