ST_Points

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

Signatures

ST_Points(geom: Geometry)

geom

Geometry

required

The input geometry.

The resulting geometry.

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

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

⌘I