PostGIS
How do I know what version of PostGreSQL I am running?
Run this simple query on any database in the server:
SELECT version();you should see a result something like:
"PostgreSQL 8.3.9 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.2-1ubuntu11) 4.3.2"The next question will logically be, how do I determine the version of PostGIS running on PostGreSQL?
query any DB with this code:
select postgis_full_version();will give a result like:
"POSTGIS="1.5.1" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.5" USE_STATS"