| From: | Alex Shnitman <alexsh(at)hectic(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | *Old* PostgreSQL version |
| Date: | 1999-06-25 12:20:15 |
| Message-ID: | 14195.29526.758797.93714@hectic.hectic.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?
Thanks! (Please CC me the reply if you can, I'm not subscribed)
--
Alex Shnitman | http://www.debian.org
alexsh(at)hectic(dot)net, alexsh(at)linux(dot)org(dot)il +-----------------------
http://alexsh.hectic.net UIN 188956 PGP key on web page
E1 F2 7B 6C A0 31 80 28 63 B8 02 BA 65 C7 8B BA
Linux represents a best-of-breed UNIX, that is trusted in mission critical
applications, and - due to it's open source code - has a long term
credibility which exceeds many other competitive OS's.
-- Internal Microsoft memo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-06-25 12:56:40 | Re: [GENERAL] Limitation |
| Previous Message | Ansley, Michael | 1999-06-25 08:04:35 | RE: Limitations |