安装PostGIS

mac

安装postgis

brew install postgis

加载插件

CREATE EXTENSION postgis;

确认插件是否加载成功

SELECT postgis_full_version();

测试

建表

CREATE TABLE geometries (name varchar, geom geometry);

插入数据

INSERT INTO geometries VALUES
  ('Point', 'POINT(0 0)'),
  ('Linestring', 'LINESTRING(0 0, 1 1, 2 1, 2 2)'),
  ('Polygon', 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'),
  ('PolygonWithHole', 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0),(1 1, 1 2, 2 2, 2 1, 1 1))'),
  ('Collection', 'GEOMETRYCOLLECTION(POINT(2 0),POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)))');

查询

SELECT name, ST_AsText(geom) FROM geometries;