ST_PolyFromText()

ST_PolyFromText creates a POLYGON geometry from WKT.

Syntax

ST_PolyFromText(wkt)

Aliases: ST_PolygonFromText().

Arguments

Argument

Description

wkt

VARCHAR WKT.

Return Value

Returns a GEOMETRY value.

Usage Notes

Examples

DROP DATABASE IF EXISTS geo_io_example;
CREATE DATABASE geo_io_example;
USE geo_io_example;

SELECT ST_AsText(ST_PolyFromText('POLYGON((0 0,1 0,1 1,0 0))')) AS polygon;

DROP DATABASE geo_io_example;

See Also

ST_PolyFromWKB(), ST_GeomFromText().