ST_Points

Description

Returns a MultiPoint containing all the coordinates of a geometry. Does not remove points that are repeated in the geometry, including the start and end points of ring geometries. (If this behavior is undesired, duplicates may be removed using ST_RemoveRepeatedPoints ).

To obtain information about the position of each coordinate in the parent geometry use ST_DumpPoints .

M and Z coordinates will be preserved if present.

This method supports Circular Strings and Curves

This function supports 3d and will not drop the z-index.

Availability: 2.3.0

Examples

SELECT ST_AsText(ST_Points('POLYGON Z ((30 10 4,10 30 5,40 40 6, 30 10))'));

--result
MULTIPOINT Z (30 10 4,10 30 5,40 40 6, 30 10 4)
			

See Also

ST_RemoveRepeatedPoints , ST_DumpPoints