Thread: transaction logging in the form of SQL statements
Is there any way to enable transaction logging in the format of SQL statements for committed transactions only ? In otherwords, a way to log all the SQL statements (including START TRANSACTION and COMMIT statements) for all committed modtype statements (INSERT UPDATE DELETE etc). Thanks, Omar
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 <omarmehmood@yahoo.com> 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 statements (including START TRANSACTION and COMMIT statements) for all committed mod type statements (INSERT UPDATE DELETE etc).
Thanks,
Omar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2010/1/12 Omar Mehmood <omarmehmood@yahoo.com>: > Is there any way to enable transaction logging in the format of SQL statements for committed transactions only ? In otherwords, a way to log all the SQL statements (including START TRANSACTION and COMMIT statements) for all committed modtype statements (INSERT UPDATE DELETE etc). no, you can log only all SQL statements. Regards Pavel Stehule > > Thanks, > Omar > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >