Yes it can be done with rules, inheritance, triggers, and updatable views. See my answer on stack overflow https://stackoverflow.com/a/78694335/4188138 https:

Yes it can be done with rules, inheritance, triggers, and updatable views. See my answer on stack overflow https://stackoverflow.com/a/78694335/4188138 https://stackoverflow.com/a/78694335/4188138 However, in my experience, it's more easily maintainable to use normal deletes, have a trigger to move it to a schemaless table (jsonb column type that contains all of the data at the time of delete), and have manual restore logic via a good UX.