Re: How to check what is current postgres version - Mailing list pgsql-general

From Scott Marlowe
Subject Re: How to check what is current postgres version
Date
Msg-id dcc563d10809081057r3838fe98n792919edfc34a8c8@mail.gmail.com
Whole thread Raw
In response to How to check what is current postgres version  ("Markova, Nina" <nmarkova@NRCan.gc.ca>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Markova, Nina"
Date:
Subject: Re: How to check what is current postgres version
Next
From: "Markova, Nina"
Date:
Subject: Postgres in a solaris zone - patch 125077-02 needed