Re: How to list user-specific configuration parameters?

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.