The ST_LineFromText() function

The ST_LineFromText() function takes a well-known text representation of type ST_LineString and a spatial reference ID and returns an ST_LineString.

Syntax

ST_LineFromText(WKT lvarchar, SRID integer)

Return type

ST_LineString

Example

The linestring_test table is created with a single ln1 ST_LineString column: 
CREATE TABLE linestring_test (ln1 ST_LineString);
The following INSERT statement inserts an ST_LineString into the ln1 column using the ST_LineFromText() function: 
INSERT INTO linestring_test VALUES(
   ST_LineFromText('linestring(10.01 20.03,20.94 21.34,35.93 19.04)',1000)
);