Обсуждение: access log for 1 table

Is there any way to set an access log for a specific table?

What I'd like to do is have a record of all access for one table. It
would be nice to do this by raising a notice and having it show up in
syslog. I could use triggers, but I would need to log for SELECT
queries as well. Rules look like like they are not the best way to go
about this, either.

Are there any ideas?

Thanks,
Peter

On Mon, 2011-09-12 at 13:42 -0500, Peter Koczan wrote:
> Is there any way to set an access log for a specific table?
>
> What I'd like to do is have a record of all access for one table. It
> would be nice to do this by raising a notice and having it show up in
> syslog. I could use triggers, but I would need to log for SELECT
> queries as well. Rules look like like they are not the best way to go
> about this, either.
>

Rules are probably not a great way to do this, but actually it's your
only option if you want to trap SELECT.


--
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com