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

Reply via email to