I know I could stop normal users from using UPDATE and DELETE by revoking permissions.
No-one (including DB admins) should be able to UPDATE or DELETE from these tables. (This is for a write-model in CQRS.)
I understand that tables will still be droppable.
How can I create append-only tables in Postgres?