PostGIS

ST_LineFromMultiPoint
Prev	7.3. Geometry Constructors	Next

ST_LineFromMultiPoint

7.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)