If you are sure that all your polygons are in actuality single polygons (you can check using numgeometries()) you can just use geometryn(geom,1) to get the data as single polygon. Note that you likely have a constraint on your table that would have to be dropped to run that in an update.
You can always use the "-S" flag in shp2pgsql to bring in geoms as single geometries when importing too. David On Wed, Apr 16, 2008 at 2:07 PM, George Silva <[EMAIL PROTECTED]> wrote: > Hello everyone, > > I have a converted dataset that has only polygons, but they were imported > from ArcGIS as Multipolygons. I need them to become simple polygons. (I dont > have any real multi-polygons in the table - they were just imported that > way. > > How can i convert this dataset to regular tyep polygons *question mark* > (no question marks on this keyboard :( ) > > Thx for the help! > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- ************************************ David William Bitner
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
