ST_DumpPoints

Introduction: Returns a MultiPoint geometry which consists of individual points that compose the input line string.

Format: ST_DumpPoints(geom: geometry)

Return type: Array<Geometry>

SQL example:

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

Output: MultiPoint ((0 0), (0 1), (1 1), (1 0), (0 0))