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.