ST_GEOGFROMTEXT ​

Creates a GEOGRAPHY object from an OGC Well-Known Text (WKT) representation.

This function is automatically invoked when casting a VARCHAR to GEOGRAPHY.

See also:

• ST_ASTEXT
• ST_GEOGFROMWKB

Syntax ​

ST_GEOGFROMTEXT(<input>)

Arguments ​

• <input>: A WKT formatted VARCHAR

Returns ​

A GEOGRAPHY type represented by the input WKT format

Example ​

SELECT ST_GEOGFROMTEXT('POINT(1 1)');
-- POINT(1 1)