Change projection of data

PL/pgSQL

ALTER TABLE tablename ALTER COLUMN geometry TYPE Geometry(Point, 4326) USING ST_Transform(geometry, 4326);
COMMIT;