CG_RotateZ — Rotates a geometry around the Z-axis by a given angle.
geometry CG_RotateZ(geometry geom, float8 angle);
Rotates the input geometry geom by angle radians around the Z-axis.
Availability: 3.6.0 - requires SFCGAL >= 2.0.0
This method needs SFCGAL backend.
This function supports 3d and will not drop the z-index.
SELECT ST_AsText(CG_RotateZ('POINT(1 0 0)', pi()/2));
-- Result: POINT(0 1 0)