Jack Flak <[EMAIL PROTECTED]> wrote in message news:<9MEG9.2902$[EMAIL PROTECTED]>... > Greetings group, > > How do I get a list of current, existing databases (catalogs) for my > current installation? > > Also: how do I find out my current version in linux? I ran this: > > /usr/local/pgsql/bin/psql --version > > and I got this: > > psql (PostgreSQL) 7.1 > > So it looks like I'm currently running 7.1. Is this the only way to > find out? > > Thanks for your time. > > > (Email address is invalid to prevent more spam) you can use a simple sql to find it out.
try: select datname from pg_database ; ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly