5. Geospatial Functions : LineFromText
 
Share this page                  
LineFromText
LINEFROMTEXT(s string [, srid integer])
Alias: ST_LINEFROMTEXT
Returns a linestring that corresponds to the Well Known Text (WKT) in s. The SRID can optionally be specified. It is ‑1 by default.
Result type: geometry
Example:
SELECT ASTEXT(LINEFROMTEXT('LINESTRING(0 0,2 2,4 0,6 6,8 0,10 10)'));
---------------------------------
col1
---------------------------------
LINESTRING (0 0, 2 2, 4 0, 6 6, 8 0, 10 10)
---------------------------------