--查询维度
select ST_CoordDim(geom) from nav_pathplan ;
--转3维
ALTER TABLE nav_pathplan
ALTER COLUMN geom TYPE geometry(GeometryZ,4326) USING st_force3d(geom)
--转2维
ALTER TABLE nav_pathplan
ALTER COLUMN geom TYPE geometry(LineString,4326)
USING st_force2d(geom)
select st_srid(geom) from nav_pathplan;
postgreql geometry 二维 三维互转
最新推荐文章于 2024-08-07 23:56:32 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)