| From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com>, doug_hall(at)aidt(dot)edu (Doug Hall) |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Listing databases |
| Date: | 2004-05-05 22:14:44 |
| Message-ID: | 200405051914.44132.martin@bugs.unl.edu.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
El Mié 05 May 2004 18:52, Mike Nolan escribió:
> > 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.
>
> Use the \l command within psql.
I guess "psql -l" is better, so you can then choose the DB. :-)
--
19:10:02 up 7 days, 32 min, 1 user, load average: 0.60, 1.02, 1.38
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CSN | 2004-05-05 22:20:12 | Re: sql standard: \' or '' |
| Previous Message | Gregory Wood | 2004-05-05 22:10:28 | Re: sql standard: \' or '' |