Re: How to list user-specific configuration parameters?

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
Thread:
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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Kerr 2009-10-26 19:58:05 Re: Postmaster taking 100% of the CPU
Previous Message Ivan Sergio Borgonovo 2009-10-26 19:48:21 Re: joining an array with a table or...?