Re: Reg: SQL Query for Postgres 8.4.3

Hi Mark,

I took the output of the Postgresql. Please find the output:

Package: postgresql-8.3
State: installed
Automatically installed: no
Version: 8.3.9-0ubuntu8.10
Priority: optional
Section: misc
Maintainer: Martin Pitt <martin(dot)pitt(at)ubuntu(dot)com>
Uncompressed Size: 14.2M
Depends: libc6 (>= 2.4), libcomerr2 (>= 1.01), libkrb53 (>= 1.6.dfsg.2),
libldap-2.4-2 (>= 2.4.7), libpam0g (>= 0.99.7.1), libpq5 (>=
8.3~beta1), libssl0.9.8 (>= 0.9.8f-5), libxml2 (>= 2.6.27),
postgresql-client-8.3, postgresql-common (>= 79), tzdata, ssl-cert,
locales
Suggests: oidentd | ident-server
Conflicts: postgresql (< 7.5)
Description: object-relational SQL database, version 8.3 server
PostgreSQL is a fully featured object-relational database management
system.
It supports a large part of the SQL standard and is designed to be
extensible
by users in many aspects. Some of the features are: ACID transactions,
foreign
keys, views, sequences, subqueries, triggers, user-defined types and
functions,
outer joins, multiversion concurrency control. Graphical user interfaces
and
bindings for many programming languages are available as well.

This package provides the database server for PostgreSQL 8.3. Servers for
other
major release versions can be installed simultaneously and are coordinated
by
the postgresql-common package. A package providing ident-server is needed
if
you want to authenticate remote connections with identd.

Regards,
Srinivas Naik

On Wed, May 5, 2010 at 1:21 AM, Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz
> wrote:

> On 05/05/10 13:15, Mark Kirkwood wrote:
>
>
> Please log into postgres do:
>
> SELECT version();
>
> (and Robert suggested)
>
>
> Should read *as* Robert suggested - sorry.
>
> Also you could do this from the os:
>
> $ aptitude show postgresql-8.3*
>
> *which will display more detail for the version.
>
> Cheers
>
> Mark
> *
>
>
> *
>