Re: List of postgreSQL databases

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Renato Oliveira <renato(dot)oliveira(at)grant(dot)co(dot)uk>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: List of postgreSQL databases
Date: 2010-04-06 11:33:52
Message-ID: 1270553632.11550.7.camel@hp-laptop2.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sergey Konoplev 2010-04-06 11:39:35 Re: List of postgreSQL databases
Previous Message Renato Oliveira 2010-04-06 11:22:19 List of postgreSQL databases