Categories
Mastering Development

Is there an automatic way to delete many rows matching a given condition from many tables?

I have a Postgres database containing many tables, each containing many rows, with many relations of all types between these different tables. If I add a new column should_delete to all of these tables, is there some automatic way I can have all rows WHERE should_delete = true deleted, without having to manually specify each […]