Name
ST_LineFromText — Makes a Geometry from WKT representation with the given SRID. If SRID is not given, it defaults to 0.
Synopsis
geometry ST_LineFromText(text WKT);
geometry ST_LineFromText(text WKT, integer srid);
Description
Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0. If WKT passed in is not a LINESTRING, then null is returned.
![[Note]](../images/note.png)
|
|
|
OGC SPEC 3.2.6.2 - option SRID is from the conformance suite. |
|
|
|
|
If you know all your geometries are LINESTRINGS, its more efficient to just use ST_GeomFromText. This just calls ST_GeomFromText and adds additional validation that it returns a linestring. |
This method implements the OGC Simple Features
Implementation Specification for SQL 1.1.
s3.2.6.2
This method implements the SQL/MM specification.
SQL-MM 3: 7.2.8
Examples
SELECT ST_AsText(ST_LineFromText('LINESTRING(1 2, 3 4)')) AS aline,
ST_LineFromText('POINT(1 2)') IS NULL AS null_return;
aline | null_return ------------------------------------ LINESTRING(1 2,3 4) | t