2013/7/23 Michael Paquier <michael.paquier@xxxxxxxxx>: > > On Tue, Jul 23, 2013 at 9:15 PM, Ian Lawrence Barwick <barwick@xxxxxxxxx> > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
