Postgres Pro
Downloads
Home   >   mailing lists

Thread: access log for 1 table

access log for 1 table

From
Peter Koczan
Date:
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

Re: access log for 1 table

From
Guillaume Lelarge
Date:
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