ST_AsExtText function [Spatial]

The ST_AsExtText function returns a binary string representing the geometry. The output format is EWKT.

Syntax

ST_AsExtText(geometry-expression)

Returns

Standards and compatibility

Example

The following returns the result SRID=4326;Point (1 2). The SRID is included in the result as a prefix.

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

Discuss this page in DocCommentXchange.