Re: How to list user-specific configuration parameters? - Mailing list pgsql-general

From Vick Khera
Subject Re: How to list user-specific configuration parameters?
Date
Msg-id 2968dfd60910261248p6c8d07b0i2388d9a719aa8aad@mail.gmail.com
Whole thread Raw
In response to How to list user-specific configuration parameters?  (Tim Landscheidt <tim@tim-landscheidt.de>)
List pgsql-general
On Mon, Oct 26, 2009 at 1:58 PM, Tim Landscheidt <tim@tim-landscheidt.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.

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: joining an array with a table or...?
Next
From: David Kerr
Date:
Subject: Re: Postmaster taking 100% of the CPU