Dear Expert, May you please provide the solution for below query.
I have to create a log for all the update query executed in database along with its username who has executed that query. However, I am able to log all the update queries in my pg_log file but it's not showing particular user who has run the query. I am using PostgreSQL 9.1 with Linux platform. Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida. ------------------------------------------------------------------ Mobile: +91-9953975849 | Ext 1078 |dinesh.chan...@cyient.com<mailto:%7cdinesh.chan...@cyient.com> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.
