Re: How to list all databases? - Mailing list pgsql-novice

From Philip Hallstrom
Subject Re: How to list all databases?
Date
Msg-id 20050822123218.V94112@wolf.pjkh.com
Whole thread Raw
In response to How to list all databases?  (cbraden <cbraden@douglasknight.com>)
List 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!

pgsql-novice by date:

Previous
From: cbraden
Date:
Subject: How to list all databases?
Next
From: Kretschmer Andreas
Date:
Subject: Re: How to list all databases?