use log_statement to log only SELECTs?

From: Brian Witt <bwitt(at)bart(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: use log_statement to log only SELECTs?
Date: 2009-11-21 01:16:21
Message-ID: 1258766181.30758.71.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks,
Brian

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2009-11-21 01:44:59 Re: Is there a tool used to display statement times from postgres logs
Previous Message Scott Marlowe 2009-11-20 23:14:47 Re: panic failed to add item