Horton

Re: Listing databases

Martin Marques <martin@bugs.unl.edu.ar>

View thread View on postgr.es
From: Martin Marques <martin@bugs.unl.edu.ar>
To: Mike Nolan <nolan@gw.tssi.com>, doug_hall@aidt.edu (Doug Hall)
Cc: pgsql-general@postgresql.org
Date: 2004-05-05T22:14:44Z
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
-----------------------------------------------------------------