Re: Reg: SQL Query for Postgres 8.4.3

Hi Mark,<br /><br /> I took the output of the Postgresql. Please find the output:<br /><br />Package: postgresql-8.3<br
/>State:installed<br />Automatically installed: no<br />Version: 8.3.9-0ubuntu8.10<br />Priority: optional<br
/>Section:misc<br /> Maintainer: Martin Pitt <<a
href="mailto:martin.pitt@ubuntu.com">martin.pitt@ubuntu.com</a>><br/>Uncompressed Size: 14.2M<br />Depends: libc6
(>=2.4), libcomerr2 (>= 1.01), libkrb53 (>= 1.6.dfsg.2),<br />         libldap-2.4-2 (>= 2.4.7), libpam0g
(>=0.99.7.1), libpq5 (>=<br />          8.3~beta1), libssl0.9.8 (>= 0.9.8f-5), libxml2 (>= 2.6.27),<br
/>        postgresql-client-8.3, postgresql-common (>= 79), tzdata, ssl-cert,<br />         locales<br />Suggests:
oidentd| ident-server<br />Conflicts: postgresql (< 7.5)<br /> Description: object-relational SQL database, version
8.3server<br /> PostgreSQL is a fully featured object-relational database management system.<br /> It supports a large
partof the SQL standard and is designed to be extensible<br />  by users in many aspects.  Some of the features are:
ACIDtransactions, foreign<br /> keys, views, sequences, subqueries, triggers, user-defined types and functions,<br
/> outerjoins, multiversion concurrency control.  Graphical user interfaces and<br />  bindings for many programming
languagesare available as well. <br /> <br /> This package provides the database server for PostgreSQL 8.3. Servers for
other<br/> major release versions can be installed simultaneously and are coordinated by<br />  the postgresql-common
package.A package providing ident-server is needed if<br /> you want to authenticate remote connections with identd.<br
/><br/><br />Regards,<br />Srinivas Naik<br /><br /><div class="gmail_quote">On Wed, May 5, 2010 at 1:21 AM, Mark
Kirkwood<span dir="ltr"><<a href="mailto:mark.kirkwood@catalyst.net.nz">mark.kirkwood@catalyst.net.nz</a>></span>
wrote:<br/><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex;
padding-left:1ex;"><div bgcolor="#ffffff" text="#000000"><div class="im"> On 05/05/10 13:15, Mark Kirkwood wrote:
<blockquotetype="cite"><br /> Please log into postgres do:<br /><br /> SELECT version();<br /><br /> (and Robert
suggested)<br /></blockquote><br /></div> Should read *as* Robert suggested - sorry.<br /><br /> Also you could do this
fromthe os:<br /><br /> $ aptitude show postgresql-8.3<span><b><br /><br /></b></span>which will display more detail
forthe version.<br /><br /> Cheers<br /><br /> Mark<br /><span><b><br /><br /><br
/></b></span></div></blockquote></div><br/>