CREATE TABLE new_table AS
SELECT
  1::INT as id,
  ST_Collect(geom)::geometry(MultiPolygonZ,2193)
FROM
  old_table