How to list user-specific configuration parameters?

Lists: pgsql-general
From: Tim Landscheidt <tim(at)tim-landscheidt(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: How to list user-specific configuration parameters?
Date: 2009-10-26 17:58:58
Message-ID: m3eioqox3x.fsf@passepartout.tim-landscheidt.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hi,

how can I list the user-specific configuration parameters,
i. e. those set by "ALTER ROLE name SET ..."?

Tim

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to list user-specific configuration parameters?
Date: 2009-10-26 19:36:26
Message-ID: 20091026193626.GJ8812@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Tim Landscheidt wrote:
> Hi,
>
> how can I list the user-specific configuration parameters,
> i. e. those set by "ALTER ROLE name SET ..."?

Get them from the pg_authid catalog.

8.5 alpha2 has a new \drds command in psql for that purpose.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to list user-specific configuration parameters?
Date: 2009-10-26 19:48:42
Message-ID: 2968dfd60910261248p6c8d07b0i2388d9a719aa8aad@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Mon, Oct 26, 2009 at 1:58 PM, Tim Landscheidt <tim(at)tim-landscheidt(dot)de> wrote:
> Hi,
>
> how can I list the user-specific configuration parameters,
> i. e. those set by "ALTER ROLE name SET ..."?

I've been using "pg_dumpall --globals-only" to view them, but it is
clearly sub-optimal to do it that way. I'm sure if you monitored the
queries pg_dumpall ran, you could figure it out. I'm just too lazy to
do that.

From: Tim Landscheidt <tim(at)tim-landscheidt(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to list user-specific configuration parameters?
Date: 2009-10-26 22:55:12
Message-ID: m3vdi1oje7.fsf@passepartout.tim-landscheidt.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:

>> how can I list the user-specific configuration parameters,
>> i. e. those set by "ALTER ROLE name SET ..."?

> Get them from the pg_authid catalog.

> 8.5 alpha2 has a new \drds command in psql for that purpose.

Thanks!

Tim