Re: Viewing another role's search path?

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Viewing another role's search path?
Date: 2013-07-23 13:03:26
Message-ID: CAB7nPqS2YRmzMYiKa_B55-npvHuxTyHBCj9kSA+cS-kFECt8eA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 23, 2013 at 9:15 PM, Ian Lawrence Barwick <barwick(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lawrence Barwick 2013-07-23 13:11:51 Re: Viewing another role's search path?
Previous Message Ondrej Chaloupka 2013-07-23 12:34:25 Re: Different transaction log for database/schema