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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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