| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Peter Koczan <pjkoczan(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: access log for 1 table |
| Date: | 2011-09-13 07:24:47 |
| Message-ID: | 1315898688.2188.7.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johann Spies | 2011-09-13 09:18:31 | Problem restoring a dump |
| Previous Message | albert | 2011-09-12 19:33:38 | Re: MSAccess migration to Postgres through ODBC |