Trigger function always logs postgres as user name

Hi, I setup trigger functions for logging, and while they do work and get triggered, the current_user always insert “postgres” even when updates/deletes/inserts are caused by users of another name. How do I get it to use the name that caused the update? It seems current_user is the trigger’s u

Re: Trigger function always logs postgres as user name

HI, The answer to the question is that you need to use session_user instead of user or current_user. Cheers, Alex > On 9 Feb 2019, at 10:08, Alexander Reichstadt wrote: > > Hi, > > I setup trigger functions for logging, and while they do work and get > triggered, the c