Re: Where to Get Version of PostgreSQL Installation - Mailing list pgsql-admin

From Marc G. Fournier
Subject Re: Where to Get Version of PostgreSQL Installation
Date
Msg-id 3C11E96D86D2C687416C2C7E@ganymede.hub.org
Whole thread Raw
Responses PostgreSQL Log Messages  (Lane Van Ingen <lvaningen@esncc.com>)
List pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- --On Thursday, December 14, 2006 10:23:04 -0500 Lane Van Ingen
<lvaningen@esncc.com> wrote:

>
> Can I tell what version of the server I am running FOR SURE by using the
> command ‘psql --version’ ??
>
> I am running 8.0.? on Windows 2003.

try:

psql -c "select version();" template1

I believe 'psql --version' gives you version of psql, not the server itself,
while select version(); wil give you the server ...

- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (FreeBSD)

iD8DBQFFgeQU4QvfyHIvDvMRAvMyAKCKaSTPUhPLZ/O+eABd2p8198ZK+wCcC/pr
Bql8Tvpl06xVbloVJvrhn90=
=87Nu
-----END PGP SIGNATURE-----


pgsql-admin by date:

Previous
From: Bill Hernandez
Date:
Subject: unsubscribe
Next
From: Joshua Colson
Date:
Subject: Change "database system identifier" in pg_control?