PostgreSQL Newbies - How to list all databases?

Author

How to list all databases?

cbraden

2005-08-22, 8:24 pm

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

Philip Hallstrom

2005-08-22, 8:24 pm

> 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/.../reference.html

good luck!

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Kretschmer Andreas

2005-08-22, 8:24 pm

cbraden < cbraden@douglasknigh
t.com> schrieb:

> 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

psql -l

> 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/8.0/static/index.html
http://www.postgresql.org/docs/8.0/...l-accessdb.html

Regards, Andreas
--
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

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

Steve Poe

2005-08-22, 8:24 pm

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links