Logging access to a column in Postgres

Question

I would like to log any access to the column col in the table schema.table. In particular, I'd like to log the time, user, and command. Is this doable?

The immediate use case is the deprecation of col in favor of a new column. Transitioning isn't automatic, and finding all instances is not straightforward, so having some automation support would be helpful. This is related to What's the best way to deprecate a column in a database schema? and What are the best practices around retiring obsolete database columns?.

Laurenz Albe · Accepted Answer · 2020-04-14 17:39:09Z

1

You can use pgAudit to log all access to a column in the PostgreSQL log file.

You would use object audit logging for that.

answered Apr 14, 2020 at 17:39

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

Logging access to a column in Postgres

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related