ST_DumpPoints

Returns list of Points which geometry consists of.

Signatures

ST_DumpPoints(geom: Geometry)

geom

Geometry

required

The input geometry.

The resulting geometry.

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

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

⌘I