ST_LinestringFromWKB — Makes a geometry from WKB with the given SRID.


geometry ST_LinestringFromWKB(bytea WKB);

geometry ST_LinestringFromWKB(bytea WKB, integer srid);


The ST_LinestringFromWKB function, takes a well-known binary representation of geometry and a Spatial Reference System ID (SRID) and creates an instance of the appropriate geometry type - in this case, a LINESTRING geometry. This function plays the role of the Geometry Factory in SQL.

If an SRID is not specified, it defaults to -1. NULL is returned if the input bytea does not represent a LINESTRING geometry. This an alias for ST_LineFromWKB.


OGC SPEC - optional SRID is from the conformance suite.


If you know all your geometries are LINESTRINGs, it's more efficient to just use ST_GeomFromWKB. This function just calls ST_GeomFromWKB and adds additional validation that it returns a LINESTRING.

This method implements the OpenGIS Simple Features Implementation Specification for SQL. OGC SPEC

This method implements the SQL/MM specification: SQL-MM 3: 7.2.9


	ST_AsBinary(ST_GeomFromText('LINESTRING(1 2, 3 4)'))
  ) AS aline,
	ST_AsBinary(ST_GeomFromText('POINT(1 2)'))
  ) IS NULL AS null_return;
   aline                            | null_return
010200000002000000000000000000F ... | t

See Also

ST_GeomFromWKB, ST_LineFromWKB