[postgis-users] create,fill with geom,attr from other table

[Brent Pedersen]

hi, i have 2 polygon tables in a postgis database.

tableA spatially covers most of the area, but there are gaps.
whereever there is a gap, i want to fill-in tableA with the
underlying (clipped) polyons,attributes in tableB which covers
the entire area.

specifically i actually have a bunch of parcel polygons in tableA, the
gaps are the roads. tableB is of large polygons of natural
features (NOT the roads). i want to fill in the tableA gaps 
(the roads) by adding records to the table and to give those
records an attribute provided by the
underlying natural features (tableB).

any pointers on how to do this? i am guessing
that i may need to do a  "Collect(the_geom)"  from  both tables, and
then run a SymDifference(), am i on the right track? or will that lose
the attributes for individual polygons in tableB?A

thanks,
-brent