Contents

List all rows that once had a certain value by using the @> operator:

SELECT DISTINCT
  audit_id 
FROM
  pgmemento.row_log
WHERE 
  old_data @> '{"column_B": "old_value"}'::jsonb;