Postgres Pro
Downloads
Home   >   mailing lists

how to get value of parameter set in session for other user - Mailing list pgsql-general

From Vikas Sharma
Subject how to get value of parameter set in session for other user
Date
Msg-id CAN6gwKz2jK__yAOvd2H55TYUw7j3BnDc4wEG-QKANOq++Zb9ug@mail.gmail.com
Whole thread Raw
Responses Re: how to get value of parameter set in session for other user  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Wicher
Date:
Subject: Re: Advice on using materialized views
Next
From: Francisco Olarte
Date:
Subject: Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT