Re: List of data bases

From: Francisco Solari <fsolari(at)prosalud(dot)com(dot)ar>
To: David Link <dlink(at)soundscan(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: List of data bases
Date: 2001-10-23 14:18:27
Message-ID: 3BD57C33.D0DF1ED6@prosalud.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Another way is to enter psql and execute \l

David Link wrote:

> > is there a way to list all data bases I've created so far?
> >
>
> One way is to list out the subdirectories under $PGDATA/base
>
> $ cd $PGDATA/base
> $ ls
>
> There should be a subdirectory per database if you haven't used
> alternate PGDATA areas.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

Attachment Content-Type Size
fsolari.vcf text/x-vcard 237 bytes

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jim Caley 2001-10-23 14:25:07 Re: List of data bases
Previous Message Brett W. McCoy 2001-10-23 14:18:14 Re: List of data bases