Re: Listing databases

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Doug Hall <doug_hall(at)aidt(dot)edu>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Listing databases
Date: 2004-05-05 21:39:00
Message-ID: Pine.LNX.4.33.0405051538470.3364-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 5 May 2004, Doug Hall wrote:

> Sorry for the newbie question, but how do you get PostgreSQL to list
> the available databases? I know how to log into a certain database, but
> not list all of them. I know this must be possible because the
> phppgAdmin web site demonstrates it with their trial server.

Assuming you're in psql just do:

\l

In response to

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2004-05-05 21:40:31 sql standard: \' or ''
Previous Message Tom Lane 2004-05-05 21:24:03 Re: question regarding cursors in plpgsql, declare and bound params (v3 protocol)