Thread: How to list all databases?
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
> 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!
cbraden <cbraden@douglasknight.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/static/tutorial-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° ;-)
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