Postgresql 中文操作指南
53.16. pg_db_role_setting #
目录 pg_db_role_setting 记录了针对各个角色和数据库组合设置的运行时配置变量的默认值。
The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database combination.
与大多数系统目录不同，pg_db_role_setting 在群集的所有数据库之间共享：每个群集只有一个 pg_db_role_setting 副本，而不是每个数据库一个。
Unlike most system catalogs, pg_db_role_setting is shared across all databases of a cluster: there is only one copy of pg_db_role_setting per cluster, not one per database.
Table 53.16. pg_db_role_setting Columns
Table 53.16. pg_db_role_setting Columns
Column Type Description |
setdatabase oid (references pg_database.oid) The OID of the database the setting is applicable to, or zero if not database-specific |
setrole oid (references pg_authid.oid) The OID of the role the setting is applicable to, or zero if not role-specific |
setconfig text[] Defaults for run-time configuration variables |