Was this helpful?
MPolyFromText
MPOLYFROMTEXT(s string [, srid integer])
Alias: ST_MPOLYFROMTEXT
Returns a multipolygon object that corresponds to the Well Known Text (WKT) in s. The SRID can optionally be specified; it is ‑1 by default.
Result type: geometry
Example:
SELECT ASTEXT(MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 0,0 0)),((0 0,10 0,10 10,0 0)))'));
--------------------------------
col1
--------------------------------
MULTIPOLYGON (((0 0, 0 10, 10 0, 0 0)), ((0 0, 10 0, 10 10, 0 0)))
--------------------------------
Last modified date: 12/14/2023