ST_DumpPoints

Introduction: Returns list of Points which geometry consists of.

Format: ST_DumpPoints(geom: Geometry)

Since: v1.5.0

Example:

SELECT ST_DumpPoints(ST_GeomFromText('LINESTRING (0 0, 1 1, 1 0)'))

Output:

[POINT (0 0), POINT (0 1), POINT (1 1), POINT (1 0), POINT (0 0)]