Re: how to get value of parameter set in session for other user

2021-12-08 Thread Vikas Sharma
Hi Tom, Thanks for the clarification. Regards Vikas On Tue, 7 Dec 2021 at 14:45, Tom Lane wrote: > Vikas Sharma writes: > > Is it possible in postgres to get the value of the parameter currently > set > > in the session of the other user? > > No. That information only exists within the other

Re: how to get value of parameter set in session for other user

2021-12-07 Thread Tom Lane
Vikas Sharma writes: > Is it possible in postgres to get the value of the parameter currently set > in the session of the other user? No. That information only exists within the other session's process. regards, tom lane

how to get value of parameter set in session for other user

2021-12-07 Thread Vikas Sharma
Hi There, Is it possible in postgres to get the value of the parameter currently set in the session of the other user? The other user might have set the value using SET . If the other user has set the value as "alter role" then it should appear in select * from pg_roles. Thank you -Vikas