Is it possible to add a z dimension to an existing 2d postgis table for future records without having to create a new table?

1 Answer 1


Use this for changing the geometry type into POINT Z and updating existing XY points into XYZ points.

ALTER TABLE d2d ALTER COLUMN geom type geometry(pointz) USING  ST_Force3D(geom);

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.