Change projection to EPSG:3857

PL/pgSQL

ALTER TABLE vml.text ALTER COLUMN wkb_geometry TYPE Geometry(Point, 3857) USING ST_Transform(wkb_geometry, 3857);
COMMIT;
ALTER TABLE vml.area ALTER COLUMN wkb_geometry TYPE Geometry(Polygon, 3857) USING ST_Transform(wkb_geometry, 3857);
COMMIT;
ALTER TABLE vml.line ALTER COLUMN wkb_geometry TYPE Geometry(Linestring, 3857) USING ST_Transform(wkb_geometry, 3857);
COMMIT;
ALTER TABLE vml.roadcline ALTER COLUMN wkb_geometry TYPE Geometry(Linestring, 3857) USING ST_Transform(wkb_geometry, 3857);
COMMIT;
ALTER TABLE vml.vectormappoint ALTER COLUMN wkb_geometry TYPE Geometry(Point, 3857) USING ST_Transform(wkb_geometry, 3857);
COMMIT;