CG_3DScale — Scales a geometry by separate factors along X, Y, and Z axes.
geometry CG_3DScale(geometry geom, float8 factorX, float8 factorY, float8 factorZ);
Scales the input geometry geom by different factors along the X, Y, and Z axes. The scaling is performed relative to the origin point (0,0,0).
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_3DScale('POINT(1 1 1)', 2, 3, 4));
-- Result: POINT(2 3 4)