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)