Re: [GENERAL] Postgres Table level statement logging
Madhu S R wrote: > Hi, > > I need to log the statements executed for a list of tables. It will be Data > Modification statements like INSERT/UPDATE/DELETE on any of these tables. > Please let me know if this is possible in postgres logging. http://andreas.scherbaum.la/blog/archives/100-Log-Table-Changes-in-PostgreSQL-with-tablelog.html Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgres Table level statement logging
On Feb 7, 2012, at 5:42 AM, Madhu S R wrote: > I need to log the statements executed for a list of tables. It will be Data > Modification statements like INSERT/UPDATE/DELETE on any of these tables. > Please let me know if this is possible in postgres logging. Yes, this possible. You can set log_statement parameter. http://www.postgresql.org/docs/current/static/runtime-config-logging.html#GUC-LOG-STATEMENT Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company Blog: http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Postgres Table level statement logging
Hi, I need to log the statements executed for a list of tables. It will be Data Modification statements like INSERT/UPDATE/DELETE on any of these tables. Please let me know if this is possible in postgres logging. Regards, Madhu
