I have a large (30m+ records) spatial data set I have imported into a PostGIS database. I did not expect to find multipolygons in the data set, but it does have a few of them. I'd like to take a closer look at them to better understand the data I'm dealing with. However,
shp2pgsql indiscriminately imported everything as a multipolygon.
How can I efficiently query the dataset to filter out the multipolygons that are actually simple polygons?