Multipart to singlepart

CREATE TABLE land_single AS (SELECT generate_series(1, ST_NumGeometries(geom)) as gid, ST_GeometryN(geom, generate_series(1, ST_NumGeometries(geom))) as geom FROM ne_10m_land);
more ...