Re: Viewing another role's search path? - Mailing list pgsql-general

From Michael Paquier
Subject Re: Viewing another role's search path?
Date
Msg-id CAB7nPqS2YRmzMYiKa_B55-npvHuxTyHBCj9kSA+cS-kFECt8eA@mail.gmail.com
Whole thread Raw
In response to Viewing another role's search path?  (Ian Lawrence Barwick <barwick@gmail.com>)
Responses Re: Viewing another role's search path?
List pgsql-general



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.
--
Michael

pgsql-general by date:

Previous
From: "Ondrej Chaloupka"
Date:
Subject: Re: Different transaction log for database/schema
Next
From: Ian Lawrence Barwick
Date:
Subject: Re: Viewing another role's search path?