How do I find out the version number

On Fri, 20 Oct 2000, Sue wrote:

I want to find out what version of PostgreSql is running. Outside of
calling someone
how can I do this? I use to be able to do the following:
select version();
while running psql. But this doesn't work any more.

select version(); works in 7.0.2. You can also do psql -V at the command
line.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
"Consequences, Schmonsequences, as long as I'm rich."
-- Looney Tunes, Ali Baba Bunny (1957, Chuck Jones)

Hi Brett,

This is the error message I receive when I try select version();
WARN: parser error at or near "version"

This is the error message I receive when I try psql -V
psql: illegal option --V

Thanks for your help
Sue

bmccoy@chapelperilous.net wrote:

On Tue, 24 Oct 2000, Sue wrote:

This is the error message I receive when I try select version();
WARN: parser error at or near "version"

This is the error message I receive when I try psql -V
psql: illegal option --V

You must be running a broken distribution. I'd ask you what version you
are using, but that's the problem, right? :-)

You might want to try and re-install Postgres, upgrading to the latest
version if you can.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
You will gain money by a speculation or lottery.

Sue <shanen@tscnet.com> writes:

This is the error message I receive when I try select version();
WARN: parser error at or near "version"

If it says "WARN" rather than "ERROR" it must be *really* ancient ---
predates 6.3 for sure, hard to tell how much further back than that.

Do yourself a favor and install 7.0.2 instead ...

regards, tom lane

second try
I use 4 disk array for the table size,
but whether it is because pgsql did not recognize separate disk volume like
oracle(alter table space),
error message came out for the lack of capacity size.
how can I make temporary size bigger?