Hi, You can use log_line_prefix in postgresql.conf to log the user name into the logs.
Regards, Ganesh Korde. On Fri, 16 Sep 2022, 6:31 pm Marcos Pegoraro, <mar...@f10.com.br> wrote: > Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver < > adrian.kla...@aklaver.com> escreveu: > >> test(5432)=# set role maura; >> ERROR: role "maura" does not exist >> test(5432)=# SET SESSION AUTHORIZATION 'maura'; >> ERROR: role "maura" does not exist >> >> No, I was asking about an error occurring later, not on set session > authorization command. > > set role maura; > --user Maura exists and set was done correctly > --now I´m working as Maura > select 1/0; -- I would like to see this exception on log being logged as > maura > > thanks > Marcos > >
