Deleting from mulitple tables - quick qu
Is there a way to delete data from multiple tables in a schema in a single command? We're looking for something like this:
delete from schema_name.* where ...
At the moment we either gather a list of all tables and write a separate delete statement for each one, or create a bash scripted loop.
Many thanks in advance for any advice.