On Tue, Apr 20, 2010 at 8:31 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Tue, Apr 20, 2010 at 6:11 AM, Devrim GÜNDÜZ <devrim@gunduz.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
Note however that other sessions won't see the change. Only
connections that come after the change will see it.