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)'