PostGIS

PostGIS_Full_Version

Prev

8.22. Version Functions

Next

Name

PostGIS_Full_Version — Reports full PostGIS version and build configuration infos.

Synopsis

text +`*`+PostGIS_Full_Version*(`)`;

Description

Reports full PostGIS version and build configuration infos. Also informs about synchronization between libraries and scripts suggesting upgrades as needed.

Examples

SELECT PostGIS_Full_Version();
                               postgis_full_version
----------------------------------------------------------------------------------
POSTGIS="3.0.0dev r17211" [EXTENSION] PGSQL="110" GEOS="3.8.0dev-CAPI-1.11.0 df24b6bb" SFCGAL="1.3.6" PROJ="Rel. 5.2.0, September 15th, 2018"
GDAL="GDAL 2.3.2, released 2018/09/21" LIBXML="2.9.9" LIBJSON="0.13.1" LIBPROTOBUF="1.3.1" WAGYU="0.4.3 (Internal)" TOPOLOGY RASTER
(1 row)

See Also

Section 3.4, “Upgrading spatial databases”, PostGIS_GEOS_Version, PostGIS_Lib_Version, PostGIS_LibXML_Version, PostGIS_PROJ_Version, PostGIS_Wagyu_Version, PostGIS_Version

Prev

Up

Next

PostGIS_Extensions_Upgrade

Home

PostGIS_GEOS_Version