I am having two tables,
I want to know which parts of
table2 intersect with
table1. Having that information, I want to write the attributes from
table1 (where they intersect) and create a completely new
table3 of it. I want to preserve the geometry (polygons) from
CREATE TABLE table3 AS SELECT t1.*, t2.c, t2.d FROM table1 t1 JOIN table2 t2 ON ST_Intersects(t1.geom, t1.geom);
Would that give me my desired result?