Track all modifications to a PostgreSQL table
32
votes
4
answers
58619
views
We have a table which has only roughly 500 rows, but it is very important for us.
I want see all changes which happen to this table. The changes should get tracked with a timestamp.
I don't want the tracking to happen in the application code, since I want to track changes which happen via
psql
shell, too.
I am happy with a PostgreSQL specific solution, since I don't use a different DB in this context.
Asked by guettli
(1591 rep)
Apr 2, 2019, 09:36 AM
Last activity: Feb 12, 2024, 03:49 PM
Last activity: Feb 12, 2024, 03:49 PM