Postgres Auditing in 150 lines of SQL
Data auditing is a system that tracks changes to tables' contents over time. PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL. Auditing is particularly useful for historical analysis.
from Pocket https://supabase.com/blog/2022/03/08/audit
via IFTTT