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@hectic.net, alexsh@linux.org.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