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

From: Vikas Sharma <shavikas(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: how to get value of parameter set in session for other user
Date: 2021-12-07 12:16:56
Message-ID: CAN6gwKz2jK__yAOvd2H55TYUw7j3BnDc4wEG-QKANOq++Zb9ug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2021-12-07 12:34:54 Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
Previous Message Wicher 2021-12-07 09:32:51 Re: Advice on using materialized views