search

2ndQuadrant / audit-trigger

Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.
Other
657 stars 241 forks source link

How to store UserName who is Updating the value of a table For Update Trigger? #31

Open Jasleen104 opened 6 years ago

Jasleen104 commented 6 years ago

Now that I am using this particular sql code for audit-trigger, I would like to see which particular user is making changes in the table along with the the following attributes:

  1. Date of change
  2. Timestamp
  3. In Table(table name)
  4. Changed Field(changed attribute)
  5. From value(old value)
  6. To value(new value) Please provide the necessary help. Thanks in advance.