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

Re: List of data bases

From: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>
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:14
Message-ID: Pine.LNX.4.30.0110231015420.29420-100000@chapelperilous.net (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, 23 Oct 2001, David Link wrote:

> 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.

A better way is to use psql -l on the command line or \l in an interactive
session.

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
Now is the time for drinking; now the time to beat the earth with
unfettered foot.
		-- Quintus Horatius Flaccus (Horace)




In response to

pgsql-novice by date

Next:From: Francisco SolariDate: 2001-10-23 14:18:27
Subject: Re: List of data bases
Previous:From: David LinkDate: 2001-10-23 13:46:52
Subject: Re: List of data bases

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