Re: Programmatic method to determine currently installed - Mailing list pgsql-general

From Richard Huxton
Subject Re: Programmatic method to determine currently installed
Date
Msg-id 4370600D.5030900@archonet.com
Whole thread Raw
In response to Re: Programmatic method to determine currently installed Windows PostrgreSQL version  (Will Wright <will4wright@yahoo.com>)
Responses Re: Programmatic method to determine currently installed Windows PostrgreSQL version
List 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

pgsql-general by date:

Previous
From: Assad Jarrahian
Date:
Subject: Re: Connect to a database in a .sql file
Next
From: Richard Huxton
Date:
Subject: Re: odbc in postgresql and php