Re: Where to Get Version of PostgreSQL Installation

From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
To: Lane Van Ingen <lvaningen(at)esncc(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Where to Get Version of PostgreSQL Installation
Date: 2006-12-14 23:53:55
Message-ID: 3C11E96D86D2C687416C2C7E@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

- --On Thursday, December 14, 2006 10:23:04 -0500 Lane Van Ingen
<lvaningen(at)esncc(dot)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(at)hub(dot)org MSN . scrappy(at)hub(dot)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-----

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-12-15 00:10:19 Re: Change "database system identifier" in pg_control?
Previous Message Joshua Colson 2006-12-14 23:40:40 Change "database system identifier" in pg_control?