On Tue, Apr 20, 2010 at 6:11 AM, Devrim GÜNDÜZ <dev...@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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to