Postgersql安装PostGIS扩展

在导入空间数据之前需要对pgsql数据库添加空间扩展,在对应的数据库下运行以下sql语句即可添加扩展:

CREATE EXTENSION postgis;

CREATE EXTENSION pgrouting;

CREATE EXTENSION postgis_topology;

CREATE EXTENSION fuzzystrmatch;

CREATE EXTENSION postgis_tiger_geocoder;

CREATE EXTENSION address_standardizer;

 

转载自:https://blog.csdn.net/yzj_xiaoyue/article/details/82786644

You may also like...

退出移动版