arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

ST_AsText

This section contains reference documentation for the ST_AsText function.

Returns the WKT representation of the geometry/geography.

hashtag
Signature

ST_AsText(geometryObject)

hashtag
Usage Examples

value
value
select stAsText(
    STPOINT(-122, 37)
) AS value
from ignoreMe 

POINT (-122 37)

select stAsText(
    ST_GeogFromText('LINESTRING (30 10, 10 30, 40 40)')
) AS value
from ignoreMe 

LINESTRING (30 10, 10 30, 40 40)