Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
The ST_AsExtText function returns a binary string representing the geometry. The output format is EWKT.
Returns the EWKT representation of the geometry-expression.
SQL/MM (ISO/IEC 13249-3: 2006)
The following returns the result SRID=4326;Point (1 2). The SRID is included in the result as a prefix.
SRID=4326;Point (1 2)
select ST_AsExtText(ST_Point 1.0, 2.0, 4326))
The following returns the result SRID=4326;Point(1 2). The ST_AsExtText() function is implicitly invoked when converting geometries to VARCHAR types.
select cast(ST_Point(1.0, 2.0, 4326) as varchar(25))