Name

PostGIS_Extensions_Upgrade — 将PostGIS扩展(例如postgis_raster、postgis_topology、postgis_sfcga)打包并升级到最新的可用版本。

Synopsis

text PostGIS_Extensions_Upgrade();

描述

将PostGIS扩展打包并升级到最新版本。如果需要,只有安装在数据库中的扩展才会打包和升级。报告完整的PostGIS版本和之后的构建配置信息。这是执行多个CREATE扩展的速记。从未打包和更改扩展名..每个PostGIS扩展模块的更新。当前仅尝试升级扩展postgis、postgis_raster、postgis_sfcga、postgis_topology和postgis_Tiger_Geocoder。

可用性:2.5.0

[Note]

已更改:3.0.0以重新打包松散扩展并支持postgis_raster。

示例

SELECT PostGIS_Extensions_Upgrade();
NOTICE:  Packaging extension postgis
NOTICE:  Packaging extension postgis_raster
NOTICE:  Packaging extension postgis_sfcgal
NOTICE:  Extension postgis_topology is not available or not packagable for some reason
NOTICE:  Extension postgis_tiger_geocoder is not available or not packagable for some reason

                    postgis_extensions_upgrade
-------------------------------------------------------------------
 Upgrade completed, run SELECT postgis_full_version(); for details
(1 row)

另请参阅

Section 3.4, “升级空间数据库”, PostGIS_GEOS_Version, PostGIS_Lib_Version, PostGIS_LibXML_Version, PostGIS_PROJ_Version, PostGIS_Version