Thanks for the help! That worked just fine. I also found this (from within psql):
# \l List of databases Database | Owner -----------+---------- template0 | postgres template1 | postgres testdb | postgres (3 rows) And this from command-line: $ /usr/local/pgsql/bin/psql -l Password: List of databases Database | Owner -----------+---------- template0 | postgres template1 | postgres testdb | postgres (3 rows) Thanks again! M.König wrote: > 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
