Name
PostGIS_Extensions_Upgrade — 将 PostGIS 扩展（例如 postgis_raster、postgis_topology、postgis_sfcgal）打包并升级到给定版本或最新版本。
Synopsis
text PostGIS_Extensions_Upgrade(text target_version=null);
描述
Packages and upgrades PostGIS extensions to given or latest version. Only extensions you have installed in the database will be packaged and upgraded if needed. Reports full PostGIS version and build configuration infos after. This is short-hand for doing multiple CREATE EXTENSION .. FROM unpackaged and ALTER EXTENSION .. UPDATE for each PostGIS extension. Currently only tries to upgrade extensions postgis, postgis_raster, postgis_sfcgal, and postgis_topology.
可用性：2.5.0
![[Note]](../images/note.png)
|
|
|
更改：3.4.0 添加 target_version 参数。 更改：3.3.0 支持从任何 PostGIS 版本升级。 不适用于所有系统。 更改：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