Re: access log for 1 table

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