Re: Programmatic method to determine currently installed

From: Richard Huxton <dev(at)archonet(dot)com>
To: Will Wright <will4wright(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Programmatic method to determine currently installed
Date: 2005-11-08 08:21:33
Message-ID: 4370600D.5030900@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Will Wright wrote:
>
> Hi Magnus, thanks for the quick response.
> Unfortunately I still have an issue with this regsitry
> identification method because I'd like to code my
> installer so that it can also identify the postreSQL
> versions that were not available at the time I
> authored my install check, i.e. future versions.

You could issue a "SELECT version()" - that is about as definitive as
you can get.

Don't forget you'll need to cope with the case where a user has 2 or
more versions of PostgreSQL running on the same machine. I'm not sure
it's safe to assume only one installation.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-11-08 08:25:48 Re: odbc in postgresql and php
Previous Message Assad Jarrahian 2005-11-08 07:31:33 Re: Connect to a database in a .sql file