2010/1/12 Omar Mehmood :
> Is there any way to enable transaction logging in the format of SQL
> statements for committed transactions only ? In other words, a way to log
> all the SQL statements (including START TRANSACTION and COMMIT statements)
> for all committed mod type statements (INSERT
Use
log_min_duration_statement=0
at postgresql.conf file to log every statement.
On Tue, Jan 12, 2010 at 7:50 AM, Omar Mehmood wrote:
> Is there any way to enable transaction logging in the format of SQL
> statements for committed transactions only ? In other words, a way to log
> all the SQL
Is there any way to enable transaction logging in the format of SQL statements
for committed transactions only ? In other words, a way to log all the SQL
statements (including START TRANSACTION and COMMIT statements) for all
committed mod type statements (INSERT UPDATE DELETE etc).
Thanks,
Oma