2013/7/23 Michael Paquier <michael.paquier@gmail.com>:
>
> On Tue, Jul 23, 2013 at 9:15 PM, Ian Lawrence Barwick <barwick@gmail.com>
> wrote:
>>
>> Is there some simple way of viewing the search path (or other
>> role-specific setting) for a role different to the current role? Apart
>> from
>> querying 'pg_db_role_setting' directly?
>
> This one perhaps?
> select rolname, rolconfig from pg_roles;
> rolconfig contains all the user-specific settings.
Thanks, but what I'm looking for is a more elegant (built-in?) way of extracting
the contents of the configuration array which is useable for people who don't
want to poke around in the system catalogues. I've created a view
which does this,
but I want to confirm if there's anything along the lines of "SHOW
search_path FOR ROLE foo"
which I've missed and would save the trouble of maintaining the view.
Regards
Ian Barwick