From: Guillaume Lelarge <guillaume@lelarge.info>
To: Peter Koczan <pjkoczan@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: access log for 1 table
Date: Tue, 13 Sep 2011 09:24:47 +0200
Message-ID: <1315898688.2188.7.camel@localhost.localdomain> (raw)
In-Reply-To: <CAFh3x0XTCaGRrLwj0GW6KgBjeUOV=kQ=_FoR7Nzc=EkudRbapw@mail.gmail.com>
References: <CAFh3x0XTCaGRrLwj0GW6KgBjeUOV=kQ=_FoR7Nzc=EkudRbapw@mail.gmail.com>
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.infohttp://www.dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, pjkoczan@gmail.com
Subject: Re: access log for 1 table
In-Reply-To: <1315898688.2188.7.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox