Re: Version Number

From: Jason Earl <jason(dot)earl(at)simplot(dot)com>
To: Ben Clewett <B(dot)Clewett(at)roadrunner(dot)uk(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Version Number
Date: 2003-03-13 18:08:50
Message-ID: 87el5b5ebx.fsf@npa01zz001.simplot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Simply connect to the server via psql (or whatever client you prefer),
and do:

SELECT version();

The output should be something like this:

template1=> select version();
version

-----------------------------------------------------------------------------------------------------
PostgreSQL 7.3.2 on i386-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030308 (Debian prerelease)
(1 row)

Ben Clewett <B(dot)Clewett(at)roadrunner(dot)uk(dot)com> writes:

> What is the eaisest way of getting the current version number from an
> installation???
>
> Thanks, Ben
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message eurlix 2003-03-13 20:43:19 what version of gcc and pg ?
Previous Message Ben Clewett 2003-03-13 16:26:15 Re: CHECK constraint