ST_GEOMFROMTEXT()

All functions > GEOSPATIAL > ST_GEOMFROMTEXT()

Creates a GEOMETRY value from a WKT (Well Known Text) string.

Signatures

WKT to geometry

Returns: A geometry value; the sub kind depends on the WKT content

ST_GEOMFROMTEXT(wkt: VARCHAR) → GEOM_MULTIANY

Signature notes:

• Accepts any valid WKT: POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION
• Returns NULL if the WKT string is NULL
• Raises an error if the WKT is malformed

Aliases

• ST_FROMTEXT

Examples

SELECT
    f1 := ST_ASTEXT(ST_GEOMFROMTEXT('POINT (1 2)')), -- Point from WKT (via ST_ASTEXT)
    f2 := ST_ASTEXT(ST_GEOMFROMTEXT('LINESTRING (0 0, 1 1, 2 2)')), -- LineString from WKT (via ST_ASTEXT)
    f3 := ST_ASTEXT(ST_GEOMFROMTEXT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))')) -- Polygon from WKT (via ST_ASTEXT)
;