ST_ASTEXT ​

Returns the OGC Well-Known Text (WKT) representation of the GEOGRAPHY. This function is automatically invoked when casting GEOGRAPHY to VARCHAR.

See also:

• ST_ASEWKT
• ST_GEOGFROMTEXT

Syntax ​

ST_ASTEXT(<input>)

Arguments ​

• <input>: The GEOGRAPHY value to be converted to WKT

Returns ​

Returns VARCHAR containing the WKT representation of the input GEOGRAPHY.

Example ​

SELECT ST_AsText('0101000020e6100000000000000000f03f000000000000f03f'::GEOGRAPHY);
-- 'POINT(1 1)'