Re: Tracking SQLs that update data - Mailing list pgsql-general

> It's far easier to adjust the logging.
>
> psql mydb
> alter mydb set log_statement='mod';



Thanks Scott.

Two questions:

1. Will this log_statement='mod' be a permanent thing, or when I have
done my testing and identifying the problem SQL, I can set it back to
default so not too much logging is being done?

2. After this statement, how or where do I find the culprit SQL?

Thanks