ST_AsText

This section contains reference documentation for the ST_AsText function.

Returns the WKT representation of the geometry/geography.
Signature
ST_AsText(geometryObject)
Usage Examples
select stAsText(
    STPOINT(-122, 37)
) AS value
from ignoreMe 
value
POINT (-122 37)
select stAsText(
    ST_GeogFromText('LINESTRING (30 10, 10 30, 40 40)')
) AS value
from ignoreMe 
value
LINESTRING (30 10, 10 30, 40 40)

value
POINT (-122 37)

value
LINESTRING (30 10, 10 30, 40 40)

ST_AsBinary

ST_Contains

Last modified 1yr ago