ST_LineFromMultiPoint — Creates a LineString from a MultiPoint geometry.
geometry ST_LineFromMultiPoint(geometry aMultiPoint);
geometry ST_LineFromMultiPoint(
)
Creates a LineString from a MultiPoint geometry.
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(ST_GeomFromEWKT('MULTIPOINT(1 2 3, 4 5 6, 7 8 9)'))); --result-- LINESTRING(1 2 3,4 5 6,7 8 9)
ST_AsEWKT, ST_Collect, ST_MakeLine