The ST_MPolyFromText() function
The ST_MPolyFromText() function takes a well-known text representation of type ST_MultiPolygon and a spatial reference ID and returns an ST_MultiPolygon.
Syntax
ST_MPolyFromText(WKT lvarchar, SRID integer)
Return type
ST_MultiPolygon
Example
The multipolygon_test table
is created with the single ST_MultiPolygon mpl1 column:
CREATE TABLE multipolygon_test (mpl1 ST_MultiPolygon);
The
following INSERT statement inserts an ST_MultiPolygon into the mp11 column
using the ST_MPolyFromText() function:
INSERT INTO multipolygon_test VALUES(
ST_MPolyFromText('multipolygon(((10.01 20.03,10.52 40.11,30.29
41.56,31.78 10.74,10.01 20.03),(21.23 15.74,21.34 35.21,28.94
35.35,29.02 16.83,21.23 15.74)),((40.91 10.92,40.56 20.19,50.01
21.12,51.34 9.81,40.91 10.92)))',1000)
);