Re: Catalog table which stores database level information

From: Feike Steenbergen <feikesteenbergen(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Shrikant Bhende <shrikantbhende(dot)net(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Catalog table which stores database level information
Date: 2017-01-08 11:46:48
Message-ID: CAK_s-G0A152tsQ=5xo8iZubJWHmLazjmnP61_JjaOe79HHkLPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8 January 2017 at 05:18, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> On 01/07/2017 08:12 PM, Shrikant Bhende wrote:
>>
>> which are applicable to the respective
>> database only, where can I get the info about the values of all
>> parameters specified at database level.
>
>
> Maybe this?:
> https://www.postgresql.org/docs/9.5/static/view-pg-settings.html
>

I think you might be looking for this one, it has settings for specific
roles and databases:

https://www.postgresql.org/docs/current/static/catalog-pg-db-role-setting.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message sin 2017-01-08 11:51:23 some amazing stuff
Previous Message Job 2017-01-08 11:24:44 R: Postgres 9.6.1 big slowdown by upgrading 8.4.22