[postgis-users] multipolygons to polygons

[Nicolas Ribot]

> Hi,
> I'm trying to run shp2pgsql with a polygon file but I'm getting the
> folloing error:
> "We have a multipolygon with 2 parts, can't use -S switch!"
>
> I know there is:
> -Multipolygons with holes.
> -Multipolygons with 2 external rings (originally one polygon cut into 2
> polygons).
>

> Is anything of this the reason why I cant use the -S switch?
>

Yes, the second one prevents shp2pgsql to convert from multipg to polygon.

> Is there a way around this to change the multipolygons to polygons?
>

Load your table with multipolygons in it, then dump them into simple
polygons, with the dump() function.

Nicolas