ST_FlipCoordinates

Introduction: Returns a version of the given geometry with X and Y axis flipped.

Format: ST_FlipCoordinates(A: Geometry)

Return type: Geometry

Since: v1.2.0

Example:

SELECT ST_FlipCoordinates(ST_GeomFromWKT("POINT (1 2)"))

Output:

POINT (2 1)