ST_GeogFromWKT

Introduction: Construct a Geography from WKT. If SRID is not set, it defaults to 0 (unknown).

Format:

ST_GeogFromWKT (Wkt: String)

ST_GeogFromWKT (Wkt: String, srid: Integer)

Return type: Geography

Since: v1.9.1

Example:

SELECT ST_GeogFromWKT('LINESTRING (1 2, 3 4, 5 6)')

Output:

LINESTRING (1 2, 3 4, 5 6)

Example with SRID:

SELECT ST_GeogFromWKT('LINESTRING (1 2, 3 4, 5 6)', 4326)

Output:

LINESTRING (1 2, 3 4, 5 6)