PostGIS_Extensions_Upgrade

Name

PostGIS_Extensions_Upgrade — Upgrades installed postgis packaged extensions (e.g. postgis_sfcgal, postgis_topology, postgis_sfcgal) to latest installed version. Reports full postgis version and build configuration infos after.

Synopsis

text PostGIS_Extensions_Upgrade ( ) ;

Description

Upgrades installed postgis packaged extensions to latest installed version. Only extensions you have installed in the database will be upgraded and if they are already at last installed version, they will not be upgraded. Reports full postgis version and build configuration infos after. This is short-hand for doing multiple ALTER EXTENSION .. UPDATE for each postgis extension. Currently only tries to upgrade extensions postgis, postgis_sfcgal, postgis_topology, and postgis_tiger_geocoder.

Availability: 2.5.0

Examples

SELECT PostGIS_Extensions_Upgrade();
NOTICE:  ALTER EXTENSION postgis_tiger_geocoder UPDATE TO "2.5.0dev";
CONTEXT:  PL/pgSQL function postgis_extensions_upgrade() line 10 at RAISE
NOTICE:  ALTER EXTENSION postgis_topology UPDATE TO "2.5.0dev";
CONTEXT:  PL/pgSQL function postgis_extensions_upgrade() line 10 at RAISE

							   postgis_extensions_upgrade
----------------------------------------------------------------------------------
POSTGIS="2.5.0dev r15966" [EXTENSION] PGSQL="100"
GEOS="3.7.0dev-CAPI-1.11.0 8fe2ce6" SFCGAL="1.3.1"
PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.2, released 2017/09/15"
LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" TOPOLOGY RASTER
(1 row)