Thread: How to list user-specific configuration parameters?

Hi,

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

Tim

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.

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.

Alvaro Herrera <alvherre@commandprompt.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