How to check what is current postgres version

select version()

Markova, Nina wrote:

Thanks

________________________________

From: justin [mailto:justin@emproshunts.com]
Sent: September 8, 2008 13:54
To: Markova, Nina
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to check what is current postgres version

select version()

Markova, Nina wrote:

Hi,

Is there any way to check the exact current version without
issuing 'psql' command?

Say, 8.2.1 or 8.2.9?

Thanks,
Nina

select version(); ??? (Note does NOT require psql, just a connection
you can issue sql over.)

Or were you looking for a way from the command line?

/usr/lib/postgresql/8.3/bin/postgres --version

works for me on centos 5.2