1 of 1

ST_AsText

This section contains reference documentation for the ST_AsText function.

Returns the WKT representation of the geometry/geography.

Signature

ST_AsText(geometryObject)

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)

This section contains reference documentation for the ST_AsText function.

Returns the WKT representation of the geometry/geography.

ST_AsText(geometryObject)

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)