On Tue, Apr 20, 2010 at 6:11 AM, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> wrote:
> On Tue, 2010-04-20 at 06:03 -0600, Scott Marlowe wrote:
>> Wouldn't this work:
>>
>> alter user smarlowe set log_statement = 'all';
>
> IIRC it only works inside the given session (so it needs to be run each
> time a query will be executed)
Not true:
psql
show log_statement;
log_statement
---------------
none
alter user smarlowe set log_statement = 'all';
show log_statement;
log_statement
---------------
all
\q
psql
show log_statement;
log_statement
---------------
all