Re: [GENERAL] transaction logging in the form of SQL statements

2010-01-11 Thread Pavel Stehule
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

Re: [GENERAL] transaction logging in the form of SQL statements

2010-01-11 Thread AI Rumman
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

[GENERAL] transaction logging in the form of SQL statements

2010-01-11 Thread 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 UPDATE DELETE etc). Thanks, Oma