Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4C1939FA324 for ; Thu, 14 Dec 2006 19:54:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 67730-07 for ; Thu, 14 Dec 2006 19:53:54 -0400 (AST) Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id 169679FA0EF for ; Thu, 14 Dec 2006 19:53:59 -0400 (AST) Received: from localhost (unknown [200.46.204.183]) by hub.org (Postfix) with ESMTP id D04BF118B3DD for ; Thu, 14 Dec 2006 19:53:54 -0400 (AST) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 39953-05; Thu, 14 Dec 2006 19:53:54 -0400 (AST) Received: from ganymede.hub.org (blk-137-79-174.eastlink.ca [24.137.79.174]) by hub.org (Postfix) with ESMTP id EA69C118B3DA; Thu, 14 Dec 2006 19:53:49 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 85FA033D4C; Thu, 14 Dec 2006 19:53:56 -0400 (AST) Date: Thu, 14 Dec 2006 19:53:55 -0400 From: "Marc G. Fournier" To: Lane Van Ingen , pgsql-admin@postgresql.org Subject: Re: Where to Get Version of PostgreSQL Installation Message-ID: <3C11E96D86D2C687416C2C7E@ganymede.hub.org> In-Reply-To: References: X-Mailer: Mulberry/4.0.6 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/205 X-Sequence-Number: 23997 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --On Thursday, December 14, 2006 10:23:04 -0500 Lane Van Ingen=20 wrote: > > Can I tell what version of the server I am running FOR SURE by using the > command =E2=80=98psql --version=E2=80=99 ?? > > 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,=20 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=3D =3D87Nu -----END PGP SIGNATURE-----