The ST_MLineFromText() function
The ST_MLineFromText() function takes a well-known text representation of type ST_MultiLineString and a spatial reference ID and returns an ST_MultiLineString.
Syntax
ST_MLineFromText(wkt lvarchar, SRID integer)
Return type
ST_MultiLineString
Example
The mlinestring_test is created
with the gid SMALLINT column that uniquely identifies the row
and the ml1 ST_MultiLineString column:
CREATE TABLE mlinestring_test (gid smallint,
ml1 ST_MultiLineString);
The
following INSERT statement inserts the ST_MultiLineString with the ST_MLineFromText() function:
INSERT INTO mlinestring_test VALUES(
1,
ST_MLineFromText('multilinestring((10.01 20.03,10.52
40.11,30.29 41.56,31.78 10.74),(20.93 20.81, 21.52 40.10))', 1000)
)