Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Vikas Sharma
Date:
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

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

From
Tom Lane
Date:
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

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

From
Vikas Sharma
Date:
Hi Tom,

Thanks for the clarification.

Regards
Vikas

On Tue, 7 Dec 2021 at 14:45, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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