ST_Points

Introduction: Returns a MultiPoint geometry consisting of all the coordinates of the input geometry. It preserves duplicate points as well as M and Z coordinates.

Format: ST_Points(geom: Geometry)

SQL Example

SELECT ST_AsText(ST_Points(ST_GeomFromEWKT('LINESTRING (2 4, 3 3, 4 2, 7 3)')));

Output:

MULTIPOINT ((2 4), (3 3), (4 2), (7,3))