• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_DB_ROLE_SETTING

PG_DB_ROLE_SETTING

PG_DB_ROLE_SETTING stores the default values that have been set for run-time configuration variables, for each role and database combination.

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