On Tue, Aug 16, 2011 at 4:02 PM, M. D. <lists@xxxxxxxxxx> wrote: > Hi everyone, > > I'm a bit lazy, or actually in a bit of a crunch. I added an audit > recording a few months ago, but never really used it much, but today I'm > seeing a bunch of suspicious activity by one user. Does someone have any > function to quickly parse this data? > that's not exactly auditable information :D i made this one for that: https://github.com/jcasanov/pg_audit it has two versions one using hstore in which you will see in old "column=>old_data" and in new "column=>new_data" seems better and i guess you can use hstore functions on it (http://www.postgresql.org/docs/9.0/static/hstore.html) The other one uses arrays to store column names, old values, new values, still more parseable -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
