Re: Finding Postgres Version????

From: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
To: Jonathon Batson <jonathon(at)octahedron(dot)com(dot)au>
Cc: Postgres Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Finding Postgres Version????
Date: 2003-02-04 07:45:00
Message-ID: 1044344700.17710.200.camel@kant.mcmillan.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, 2003-02-04 at 14:08, Jonathon Batson wrote:
> Hi...
>
> Does anyone know the command to find the current version # of Postgres??

andrew(at)kant ~ $ psql template1
Welcome to psql 7.3.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

template1=# select version();

version
-----------------------------------------------------------------------------------------------------
PostgreSQL 7.3.1 on i386-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2
20030109 (Debian prerelease)
(1 row)

template1=#

Regards,
Andrew.
--
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267
Survey for nothing with http://survey.net.nz/
---------------------------------------------------------------------

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Adam Witney 2003-02-04 10:42:52 Re: Mac OsX
Previous Message Justin Clift 2003-02-04 06:27:15 Re: [ADMIN] Database access problem : SOS