ST_MPolyFromText

Introduction: Construct a MultiPolygon from Text and Optional SRID

Format:

ST_MPolyFromText (Wkt: String)

ST_MPolyFromText (Wkt: String, Srid: Integer)

Return type: Geometry

Since: 1.3.1

Example:

SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0 1,20 0 1,20 20 1,0 20 1,0 0 1),(5 5 3,5 7 3,7 7 3,7 5 3,5 5 3)))')

Output:

MULTIPOLYGON (((0 0, 20 0, 20 20, 0 20, 0 0), (5 5, 5 7, 7 7, 7 5, 5 5)))