POSTGIS_FULL_VERSION
📄字数 346
👁️阅读量 加载中...
功能描述
报告完整的 PostGIS 版本和构建配置信息。
语法格式
sql
POSTGIS_FULL_VERSION参数说明
无
函数返回类型
VARCHAR类型
示例
sql
SQL> SELECT POSTGIS_FULL_VERSION();
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| EXPR1 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| POSTGIS="3.5.0dev 3.5.0dev" [EXTENSION] PGSQL="161" GEOS="3.12.1-CAPI-1.18.1" SFCGAL="SFCGAL 1.5.0, CGAL 5.6.1, BOOST 1.85.0" PROJ="9.3.1 NETWORK_ENABLED=OFF URL_ENDPOINT= USER_WRITABLE_DIRECTORY=/root/.local/share/proj" GDAL="GDAL 3.8.5, released 2024/04/02 GDAL_DATA not found" LIBXML="2.9.10" LIBJSON="0.17" RASTER |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+