Skip to main content
Constructs a Geography object from a WKT (Well-Known Text) string. If SRID is not set, it defaults to 0 (unknown). This is the geography equivalent of ST_GeomFromText.

​
Signatures

ST_GeogFromText(wkt: String)

ST_GeogFromText(wkt: String, srid: Integer)

​
Parameters

​
wkt
String
required
A Well-Known Text (WKT) representation of a geometry.
​
srid
Integer
Spatial Reference Identifier. Defaults to 0 if not specified.

​
Return type

The constructed geography object.

​
Examples

SELECT ST_GeogFromText('POINT (-122.4194 37.7749)')

POINT (-122.4194 37.7749)

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

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