There's also another way using hstore instead of json:
https://wiki.postgresql.org/wiki/Audit_trigger_91plus
--
View this message in context:
http://postgresql.nabble.com/comparing-two-JSON-objects-in-9-3-tp5803617p5897128.html
Sent from the PostgreSQL - general mailing list archive at Nabble.c
Wow. This is exactly what I'm looking for . The standard audit from here
https://wiki.postgresql.org/wiki/Audit_trigger is not good enough for me - I
want to audit only changed values and ignore all other ones.
Thank you Felix!
Regards,
Yuri.
--
View this message in context:
http://postgresql.
Ahoi
I'm developing an auditing mechanism where table contents are logged as JSON (github.com/fxku/audit).
At first I just logged the whole row everytime my triggers were fired.
Now I'm trying to log only the old state of values that have changed.
Therefore I compare the OLD and NEW entry
