ST_MakeLine¶

Creates a LineString from two or more input geometries or geographies.

Usage¶

geometry ST_MakeLine(geomA: geometry, geomB: geometry)
geography ST_MakeLine(geogA: geography, geogB: geography)

Arguments¶

geogA (geography): Input geography
geogB (geography): Input geography
geomA (geometry): Input geometry
geomB (geometry): Input geometry

Description¶

Creates a LineString from two or more input Point, MultiPoint, or LineString geometries or geographies. The function connects the inputs in the order they are provided to form a single continuous line. Combining geographies returns a geography.

Examples¶

SELECT ST_MakeLine(ST_Point(0, 1), ST_Point(2, 3)) as geom;

┌─────────────────────┐
│         geom        │
│       geometry      │
╞═════════════════════╡
│ LINESTRING(0 1,2 3) │
└─────────────────────┘