| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | Madhu S R <s_r_madhu(at)yahoo(dot)co(dot)in> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgres Table level statement logging |
| Date: | 2012-02-07 17:15:18 |
| Message-ID: | 15741007-7170-48BE-82DD-69BEB48F51AB@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2012-02-07 17:21:30 | Re: Postgres Table level statement logging |
| Previous Message | Merlin Moncure | 2012-02-07 15:06:49 | Re: How to write in Postgres |