Thread: Checking Postgres Version Question

Hi,

Is there a way to check which version of Postgres is installed on a
particular Linux box without query the RPM database?

For instance, is there a "psql --version" command, or something similar,
that I can use?

Thanks,
John

2008/8/28 John <lists@johndubchak.com>:
> Hi,
>
> Is there a way to check which version of Postgres is installed on a
> particular Linux box without query the RPM database?
>
> For instance, is there a "psql --version" command, or something similar,
> that I can use?
>
> Thanks,
> John
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

select version();

(for the server version)

psql --version

(for the client version)

Peter