PostgreSQL Table-Tracking Utility?

Question

I'd like to see a transactional history of operations that have been executed on one of my tables, and which user executed each operation. Does PostgreSQL offer any tools that allow that kind of historical lookup?

When you say operation are you talking DML or DDL? For DDL 9.3 will have some built ins depesz.com/2012/07/29/waiting-for-9-3-event-triggers. — Kuberchaun
– Kuberchaun, Commented Jun 14, 2013 at 16:27

Community · Accepted Answer · 2017-05-23 12:21:34Z

1

Maybe others can inform you if there are any good utilities that handle this for you, but I know triggers can be used to create audit logs of tables. If you need more complex logic for how and what you want to audit you can also write procedural functions and incorporate them in your triggers. Example: Postgres trigger function

See this link: http://wiki.postgresql.org/wiki/Audit_trigger_91plus

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Jun 14, 2013 at 17:00

Ben DeMott

3,6441 gold badge29 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL Table-Tracking Utility?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related