how to get value of parameter set in session for other user
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 <parameter>.
If the other user has set the value as "alter role" then it should appear
in select * from pg_roles.
Thank you
-Vikas
Vikas Sharma <shavikas@gmail.com> 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
Hi Tom,
Thanks for the clarification.
Regards
Vikas
On Tue, 7 Dec 2021 at 14:45, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Show quoted text
Vikas Sharma <shavikas@gmail.com> 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