arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

ST_GeogFromText

This section contains reference documentation for the ST_GeogFromText function.

Return a specified geography value from Well-Known Text representation or extended (WKT)arrow-up-right

hashtag
Signature

ST_GeogFromText(wkt)

hashtag
Usage Examples

value
value
value
select ST_GeogFromText('POINT (30 10)') AS value
from ignoreMe 

80403e0000000000004024000000000000

82000000010000000300000000403e00000000000040240000000000004024000000000000403e00000000000040440000000000004044000000000000

84000000010000000500000000403e0000000000004024000000000000402400000000000040340000000000004034000000000000404400000000000040440000000000004044000000000000403e0000000000004024000000000000

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