Delete from a table where the geometry intersects the geometry of another table?

Question

Is there a way to delete data in one table that intersects the geomety of another table? I am using PostGIS.

Effectively I would like to do the following, but this returns an error.

DELETE FROM table_A
WHERE st_intersects(table_A.geom, table_B.geom)

Answer 1

You need to reference the second table with USING:

DELETE FROM table_A AS a
USING table_B AS b
WHERE ST_Intersects(a.geom, b.geom);

See the docs under 'Notes' for details.