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.
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
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.