Re: [GENERAL] *Old* PostgreSQL version - Mailing list pgsql-general

From Remigiusz Sokolowski
Subject Re: [GENERAL] *Old* PostgreSQL version
Date
Msg-id Pine.GS4.4.02A.9906251529550.9174-100000@netra.gdansk.sprint.pl
Whole thread Raw
In response to *Old* PostgreSQL version  (Alex Shnitman <alexsh@hectic.net>)
List pgsql-general
> Hi!
>
> I read in the FAQ that in order to find out the version of PostgreSQL
> I'm running I have to so "select version();" from psql. I have a very
> old installation of PostgreSQL that I need to upgrade, so I need to
> find out its version, but this trick doesn't work:
>
> database_name=> select version();
> WARN:parser: Syntax error at or near "version"
>
> What else can I do? I can see from the dates of the files that it was
> installed sometime in mid-1997. What else can I use to find the
> version?

AFAIK
in database system directory there is some file with name PG_VERSION -
maybe this way You can find out what version You use.
But I have 6.3.2 version, and don't know if this file is in older versions
    Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski      e-mail: rems@gdansk.sprint.pl           * *
-----------------------------------------------------------------*****----------


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] *Old* PostgreSQL version
Next
From: Alex Shnitman
Date:
Subject: Re: [GENERAL] *Old* PostgreSQL version