Catalog table which stores database level information

On 01/07/2017 08:12 PM, Shrikant Bhende wrote:

Hi all,

I am trying to find out the catalog table which stores the information
about database level changes. As we can alter the values of the
parameters on database level, 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

If not can you be more specific about what parameters you are referring to?

Thanks and Regards.
--
Shrikant Bhende
+91-9975543712

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 8 January 2017 at 05:18, Adrian Klaver <adrian.klaver@aklaver.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