Audit record row access
Where should I start if I want to log access to records and store their ids and what user accessed them? Its not clear how I can use pgaudit, that seems more geared to logging record changes not record access. It looks like I cant attach a trigger for records based on SELECT either. Id like this to be done as close to the db as possible so I can also log access when I am in the dashboard otherwise Id build something at the application level.
