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.8.0

SQL Example

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

Output:

LINESTRING (1 2, 3 4, 5 6)

SQL Example

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

Output:

SRID=4326; LINESTRING (1 2, 3 4, 5 6)