Sample Header Ad - 728x90

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