On 20/04/2010 10:33 PM, Scott Marlowe wrote:
>> psql
>> show log_statement;
>> log_statement
>> ---------------
>> all
>
> Note however that other sessions won't see the change. Only
> connections that come after the change will see it.
Also, as the OP wants to use it for auditing, it's worth noting that
it's trivial for the audited user to simply disable log_statement in a
session with a SET command.
--
Craig Ringer