I am using two polygon tables in postgis (A and B ). I need to make a vector file that incorporates information of the overlapped polygons B intersecting each polygon on (A).
I can make a single shapefile for each polygon of A with the resulting intersections and other info of B.
Is there a way in which I could "merge" all these resulting polygons (each with its own attributes) into a single file ?
I was thinking that maybe using an array column but I also need other info related to the intersection like area and percentage of coverage.