Обсуждение: Log statements by username

Hi,

We have a database that is accessible to quite a few users. (Using their
own account name of course)
Our goal is to be able to log the users UPDATE statements, so that we
can track down changes that were not done by our application software.

  Altering the log_statement parameter is not an option, since this
would generate enormous amounts of statements. I'm interested in certain
users only. (or in fact all but one user)

One approach i have tried is to create a RULE that filters queries from
the application software user out. It then updates a log table for every
update, but i am unable to get a hold of the actual query that is executing.

Any ideas?


Regards,
David