Re: list databases with SQL command - Mailing list pgsql-general

From Richard Huxton
Subject Re: list databases with SQL command
Date
Msg-id 41ECF157.5080907@archonet.com
Whole thread Raw
In response to list databases with SQL command  (David Teran <david.teran@cluster9.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: list databases with SQL command
Next
From: Antony Paul
Date:
Subject: What is xmin ?