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: (view raw or whole 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

-- Brett
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-2015 The PostgreSQL Global Development Group