On Tue, Apr 20, 2010 at 8:31 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Tue, Apr 20, 2010 at 6:11 AM, Devrim GÜNDÜZ <devrim@xxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
