Postgres Pro
Downloads
Home   >   mailing lists

Re: List of postgreSQL databases - Mailing list pgsql-admin

From Devrim GÜNDÜZ
Subject Re: List of postgreSQL databases
Date
Msg-id 1270553632.11550.7.camel@hp-laptop2.gunduz.org
Whole thread Raw
In response to List of postgreSQL databases  (Renato Oliveira <renato.oliveira@grant.co.uk>)
Responses Re: List of postgreSQL databases  (Renato Oliveira <renato.oliveira@grant.co.uk>)
List pgsql-admin
Tree view 
On Tue, 2010-04-06 at 12:22 +0100, Renato Oliveira wrote:
>
> I know to get a list of all databases on the system one can use: \l or
> (back slash) (ell)
>
> Is there a specific 'STATEMENT' to display the same thing?

Run psql with -E parameter, and then run \l. You'll see the query
there .

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
Attachment

pgsql-admin by date:

Previous
From: Renato Oliveira
Date:
Subject: List of postgreSQL databases
Next
From: Sergey Konoplev
Date:
Subject: Re: List of postgreSQL databases