PostGIS

ST_LineFromMultiPoint
Prev	8.3. Geometry Constructors	Next

ST_LineFromMultiPoint

8.3. Geometry Constructors

Name

ST_LineFromMultiPoint — Creates a LineString from a MultiPoint geometry.

+geometry +ST_LineFromMultiPoint(+`geometry `+aMultiPoint`)`;

Creates a LineString from a MultiPoint geometry.

Use ST_MakeLine to create lines from Point or LineString inputs.

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

Create a 3D line string from a 3D MultiPoint

SELECT ST_AsEWKT(  ST_LineFromMultiPoint('MULTIPOINT(1 2 3, 4 5 6, 7 8 9)')  ));

--result--
LINESTRING(1 2 3,4 5 6,7 8 9)