ST_ASEWKT ​

Returns the Extended Well-Known Text (EWKT) representation of a GEOGRAPHY object, which includes the SRID prefix.

See also:

• ST_ASTEXT
• ST_GEOGFROMTEXT

Syntax ​

ST_ASEWKT(<input>)

Arguments ​

• <input>: The GEOGRAPHY object to be converted to EWKT format

Returns ​

A VARCHAR containing the EWKT representation of the input GEOGRAPHY, prefixed with its SRID.

Example ​

SELECT ST_AsEWKT(ST_Point(1, 1)::GEOGRAPHY);
-- 'SRID=4326;POINT(1 1)'