I am currently creating this using the following sql statement.

select st_setsrid((st_dump(st_polygonize(st_geometryn(geom,n)))).geom, 
2266) from
	(select generate_series(1,numgeometries(st_union(lines.geom))) as n,  
st_union(lines.geom) as geom from
		(select st_astext(st_boundary((st_dumprings(polys.geom)).geom)) as  
geom from
			(select (st_dump(the_geom)).geom from test where geometrytype 
(the_geom)='MULTIPOLYGON')
			as polys)
		as lines)
	as mline;

I think this only works polygons with no holes.

Is there a better way to do this using intersections?

Thanks,

Paul