Re: How to check what is current postgres version

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

On Mon, Sep 8, 2008 at 11:40 AM, 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