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