Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: fsolari.vcf
Description: text/x-vcard (237 bytes)

In response to

pgsql-novice by date

Next:From: Jim CaleyDate: 2001-10-23 14:25:07
Subject: Re: List of data bases
Previous:From: Brett W. McCoyDate: 2001-10-23 14:18:14
Subject: Re: List of data bases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group