Re: Listing databases - Mailing list pgsql-general

From Martin Marques
Subject Re: Listing databases
Date
Msg-id 200405051914.44132.martin@bugs.unl.edu.ar
Whole thread Raw
In response to Re: Listing databases  (Mike Nolan <nolan@gw.tssi.com>)
List 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
-----------------------------------------------------------------

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: sql standard: \' or ''
Next
From: snpe
Date:
Subject: Re: help me