Log update query along with username who has executed the same.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.chandra@xxxxxxxxxx

Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.

 


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux