| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| 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:58:23 |
| Message-ID: | 20040505215823.GE24026@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, May 05, 2004 at 04:20:29PM -0500, 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.
With psql, you can use
psql -l
Else see the pg_database table.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"En las profundidades de nuestro inconsciente hay una obsesiva necesidad
de un universo lógico y coherente. Pero el universo real se halla siempre
un paso más allá de la lógica" (Irulan)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Witney | 2004-05-05 21:59:44 | Re: Listing databases |
| Previous Message | Mike Nolan | 2004-05-05 21:52:49 | Re: Listing databases |