Thread: How to check what is current postgres version

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

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

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

On Mon, Sep 8, 2008 at 11:40 AM, Markova, Nina <nmarkova@nrcan.gc.ca> 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