PostGIS 复制表和投影转换

1. 如果存在先删除

DROP TABLE IF EXISTS poibeijing_3857;

2. 复制表

CREATE TABLE layer_3857 AS
SELECT *
FROM layer;

3. 投影转换

ALTER TABLE poibeijing_3857
    ALTER COLUMN geom
        TYPE Geometry(Point, 3857)
        USING ST_Transform(geom, 3857);