PG_DB_ROLE_SETTING

PG_DB_ROLE_SETTING records the default values of configuration items bonded to each role and database when the database is running.

**Table 1** PG_DB_ROLE_SETTING columns
Name	Type	Description
setdatabase	oid	Database corresponding to the configuration items; the value is 0 if the database is not specified
setrole	oid	Role corresponding to the configuration items; the value is 0 if the role is not specified
setconfig	text[]	Default value of configuration items when the database is running

Parent topic: System Catalogs

Last Article: PG_DATABASE

Did this article solve your problem?

Thank you for your score！Your feedback would help us improve the website.

Help Center