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

Re: How to list all databases?

From: Philip Hallstrom <postgresql(at)philip(dot)pjkh(dot)com>
To: cbraden <cbraden(at)douglasknight(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to list all databases?
Date: 2005-08-22 19:33:43
Message-ID: 20050822123218.V94112@wolf.pjkh.com (view raw or flat)
Thread:
Lists: pgsql-novice
> 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.

Connect using psql and then type "\l" (ell) to list the databases...

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

http://www.postgresql.org/docs/

Perhaps this for starters which has info on psql and other client/server 
apps...

http://www.postgresql.org/docs/7.4/interactive/reference.html

good luck!

In response to

pgsql-novice by date

Next:From: cbradenDate: 2005-08-22 20:46:34
Subject: New-B Question #2
Previous:From: Kretschmer AndreasDate: 2005-08-22 19:31:21
Subject: Re: How to list all databases?

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