ST_MPolyFromText

Construct a MultiPolygon from Wkt. If srid is not set, it defaults to 0 (unknown).

Signatures

ST_MPolyFromText (Wkt: String)

ST_MPolyFromText (Wkt: String, srid: Integer)

Wkt

String

required

A Well-Known Text (WKT) representation of a geometry.

srid

Integer

Spatial Reference Identifier.

The resulting geometry.

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)))')

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