Re: How to list user-specific configuration parameters?

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2009-10-26 19:43:19 Re: [ANNOUNCE] PGDay.EU 2009 - approaching fast!
Previous Message Alvaro Herrera 2009-10-26 19:10:46 Re: Why does pg_dump set default_with_oids to true?