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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
