Re: [PERFORM] Log update query along with username who has executed the same.

2017-05-23 Thread Dinesh Chandra 12108
com> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. From: Rick Otten [mailto:rottenwindf...@gmail.com] Sent: 23 May, 2017 6:19 PM To: Dinesh Chandra 12108 Cc: pgsql-performance@postgresql.org Subject: [EXTERNAL] Re: [PERFORM] Log update query along with username who has ex

Re: [PERFORM] Log update query along with username who has executed the same.

2017-05-23 Thread Rick Otten
You need to include "%u" in the log_line_prefix setting in your postgresql.conf. Like this: log_line_prefix = '%m %d %h %u ' > > #log_line_prefix = '' # special values: > > # %a = application name > > # %u = user name > > #