Re: [GENERAL] Missing variable "role" in "pg_settings"?

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>>Based on this email, should we be showing ROLE from SHOW ALL?
> Only if you think we should be showing session_authorization too.
> That was marked "no_show_all" quite a long time ago, and we have
> not got complaints about it...

Hm, but before 8.1 there was no "alter user set <variable> <value>", was
there? So, a automatic way of retrieving all possible variables wasn't
too important - at least not from a gui-tool perspektive..

Maybe pg_show_all_settings could take an additional parameter indicating
wether to show NO_SHOW_ALL variables or not?

Just my 2 (euro)-cent...

greetings, Florian Pflug