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

Re: How to list all databases?

From: Steve Poe <spoe(at)sfnet(dot)cc>
To: cbraden(at)douglasknight(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to list all databases?
Date: 2005-08-23 01:37:39
Message-ID: 1124761059.12103.15.camel@amd64-laptop-spoe (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Mr. Char-Lez Braden,

from the command line, you can run 'psql -l' to list all the databases.

Steve Poe

On Mon, 2005-08-22 at 14:59 -0400, cbraden wrote:
> Hello,
> I'm super new to PostgreSQL, but not SQL or RDAs in general.  I have 
> inherited a system where no one knows anything about it.  I'd like to 
> start by just finding out what databases are on it, and also what users 
> are created.
> What I really need is a good reference.  The only I have, PostgreSQL by 
> Korry Douglas and Susan Douglas is pretty good but it is more of a 
> tutorial based learning tool.
> Anything you can tell me would be appriciated.
> Thanks,
> Mr. Char-Lez Braden
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

In response to

pgsql-novice by date

Next:From: Alex du PlessisDate: 2005-08-23 03:28:39
Subject: Created objects not visible
Previous:From: cbradenDate: 2005-08-22 20:46:34
Subject: New-B Question #2

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