RE: [GENERAL] Version of a Postgres installation

from within psql:

Select version();

    -----Original Message-----
    From:    Neil Burrows [SMTP:maillist@remo.demon.co.uk]
    Sent:    Saturday, May 08, 1999 5:13 AM
    To:    pgsql-general@postgreSQL.org
    Subject:    [GENERAL] Version of a Postgres installation

    Hi,


    How would a user find out which version of PostgreSQL they are
using?

    I've had a look thought the archives for this but the only answer I
have
    found is to check the PG_VERSION file in the data directory.  This
is all
    very well if the have postmaster privileges and can access that
directory,
    but what about a user on a shared machine?  For example someone
who's ISP
    allows them to use PostgreSQL?

    I know they could ask the system administrator but is there not a
quick and
    easy way of finding out the version number?

    Many regards,

    ---[  Neil Burrows
]-----------------------------------------------------
    E-mail: neil@pawprint.co.uk                         ** This e-mail
was  **
    Web   : http://www.remo.demon.co.uk/                ** Made in
Scotland **
    -------< PGP Key available from http://www.remo.demon.co.uk/pgp/
>--------