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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
