Brian Witt wrote: > Hi, > > I've been looking for a way to use log_statement to log only select > statements; is this possible? (I'm using PostgreSQL 8.1.18) > > I'd like to know if someone tried to read the data back from the > database, but don't care to see the inserts or updates since these may > have sensitive data like credit card data which I don't want logged in > the logs. I really don't even care if the SELECT was successful or not, > or what the results of the SELECT were. No, log_statement doesn't allow do that, and I can't think of another option. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general