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)