Re: access log for 1 table - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: access log for 1 table
Date
Msg-id 1315898688.2188.7.camel@localhost.localdomain
Whole thread Raw
In response to access log for 1 table  (Peter Koczan <pjkoczan@gmail.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: shuaixf
Date:
Subject: Re: how can I get the length of columns of a table by system tables/views
Next
From: Johann Spies
Date:
Subject: Problem restoring a dump