postgis： Geometry has Z dimension but column does not

如何修改column的属性呢：

参考1：https://blog.csdn.net/weixin_42488402/article/details/126545156

参考2：https://blog.csdn.net/qq_43677942/article/details/128116223

参考3：https://gis.stackexchange.com/questions/178792/geojson-in-postgis-geometry-z-dimension-error

I try change the dimension with :

ALTER TABLE urbana_prueba  
ALTER COLUMN geom TYPE geometry(MultiPolygon, 3857) 
USING ST_Force_3D(geom);

but dosen't work......

回答：You were almost there...

MultiPolygonZ should do the trick:

ALTER TABLE urbana_prueba  
ALTER COLUMN geom TYPE geometry(MultiPolygonZ, 3857) 
USING ST_Force_3D(geom);