I'd like to be able to track changes made to a database (PostgreSQL) over the past month. I know of two options:
- database triggers
- change data capture of the write-ahead log
But is there no way to query the write-ahead log directly from the database itself? I.e. something like
SELECT *
FROM WRITE_AHEAD_LOG
WHERE table='mytable' AND event_timestamp>'2018-01-01' etc?