Craig Ringer wrote:
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.
From the docs for log_statement: "Only superusers can change this
setting. "
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
