Skip to main content
Construct a Polygon from Text, delimited by Delimiter. Path must be closed

​
Signatures

ST_PolygonFromText (Text: String, Delimiter: Char)

​
Parameters

​
Text
String
required
The text value.
​
Delimiter
Char
required
The delimiter value.

​
Return type

The resulting geometry.

​
Example

SELECT ST_PolygonFromText('-74.0428197,40.6867969,-74.0421975,40.6921336,-74.0508020,40.6912794,-74.0428197,40.6867969', ',')

POLYGON ((-74.0428197 40.6867969, -74.0421975 40.6921336, -74.050802 40.6912794, -74.0428197 40.6867969))