System catalog tables v14

The following system catalog tables contain definitions of database objects. The layout of the system tables is subject to change, if you are writing an application that depends on information stored in the system tables, it would be prudent to use an existing catalog view, or create a catalog view to isolate the application from changes to the system table.

edb_dir

The edb_dir table contains one row for each alias that points to a directory created with the CREATE DIRECTORY command. A directory is an alias for a pathname that allows a user limited access to the host file system.

You can use a directory to fence a user into a specific directory tree within the file system. For example, the UTL_FILE package offers functions that permit a user to read and write files and directories in the host file system, but only allows access to paths that the database administrator has granted access to via a CREATE DIRECTORY command.

ColumnTypeModifiersDescription
dirname"name"not nullThe name of the alias.
dirowneroidnot nullThe OID of the user that owns the alias.
dirpathtextThe directory name to which access is granted.
diraclaclitem[]The access control list that determines which users may access the alias.

edb_all_resource_groups

The edb_all_resource_groups table contains one row for each resource group created with the CREATE RESOURCE GROUP command and displays the number of active processes in each resource group.

ColumnTypeModifiersDescription
group_name"name"The name of the resource group.
active_processesintegerNumber of currently active processes in the resource group.
cpu_rate_limitfloat8Maximum CPU rate limit for the resource group. 0 means no limit.
per_process_cpu_rate_limitfloat8Maximum CPU rate limit per currently active process in the resource group.
dirty_rate_limitfloat8Maximum dirty rate limit for a resource group. 0 means no limit.
per_process_dirty_rate_limitfloat8Maximum dirty rate limit per currently active process in the resource group.

edb_policy

The edb_policy table contains one row for each policy.

ColumnTypeModifiersDescription
policynamenamenot nullThe policy name.
policygroupoidnot nullCurrently unused.
policyobjectoidnot nullThe OID of the table secured by this policy (the object_schema plus the object_name).
policykindcharnot nullThe kind of object secured by this policy:

'r' for a table

'v' for a view

= for a synonym

Currently always 'r'.
policyprocoidnot nullThe OID of the policy function (function_schema plus policy_function).
policyinsertbooleannot nullTrue if the policy is enforced by INSERT statements.
policyselectbooleannot nullTrue if the policy is enforced by SELECT statements.
policydeletebooleannot nullTrue if the policy is enforced by DELETE statements.
policyupdatebooleannot nullTrue if the policy is enforced by UPDATE statements.
policyindexbooleannot nullCurrently unused.
policyenabledbooleannot nullTrue if the policy is enabled.
policyupdatecheckbooleannot nullTrue if rows updated by an UPDATE statement must satisfy the policy.
policystaticbooleannot nullCurrently unused.
policytypeintegernot nullCurrently unused.
policyoptsintegernot nullCurrently unused.
policyseccolsint2vectornot nullThe column numbers for columns listed in sec_relevant_cols.

edb_profile

The edb_profile table stores information about the available profiles. edb_profiles is shared across all databases within a cluster.

ColumnTypeReferencesDescription
oidoidRow identifier (hidden attribute, must be explicitly selected).
prfnamenameThe name of the profile.
prffailedloginattemptsintegerThe number of failed login attempts allowed by the profile. -1 indicates that the value from the default profile should be used. -2 indicates no limit on failed login attempts.
prfpasswordlocktimeintegerThe password lock time associated with the profile (in seconds). -1 indicates that the value from the default profile should be used. -2 indicates that the account should be locked permanently.
prfpasswordlifetimeintegerThe password life time associated with the profile (in seconds). -1 indicates that the value from the default profile should be used. -2 indicates that the password never expires.
prfpasswordgracetimeintegerThe password grace time associated with the profile (in seconds). -1 indicates that the value from the default profile should be used. -2 indicates that the password never expires.
prfpasswordreusetimeintegerThe number of seconds that a user must wait before reusing a password. -1 indicates that the value from the default profile should be used. -2 indicates that the old passwords can never be reused.
prfpasswordreusemaxintegerThe number of password changes that have to occur before a password can be reused. -1 indicates that the value from the default profile should be used. -2 indicates that the old passwords can never be reused.
prfpasswordverifyfuncdboidpg_database.oidThe OID of the database in which the password verify function exists.
prfpasswordverifyfuncoidpg_proc.oidThe OID of the password verify function associated with the profile.

edb_redaction_column

The catalog edb_redaction_column stores information of data redaction policy attached to the columns of the table.

ColumnTypeReferencesDescription
oidoidRow identifier (hidden attribute, must be explicitly selected).
rdpolicyidoidedb_redaction_policy.oidThe data redaction policy applies to the described column.
rdrelidoidpg_class.oidThe table that the described column belongs to.
rdattnumint2pg_attribute.attnumThe number of the described column.
rdscopeint2The redaction scope: 1 = query, 2 = top_tlist, 4 = top_tlist_or_error
rdexceptionint2The redaction exception: 8 = none, 16 = equal, 32 = leakproof
rdfuncexprpg_node_treeData redaction function expression
Note

The described column is redacted if the redaction policy edb_redaction_column.rdpolicyid on the table is enabled and the redaction policy expression edb_redaction_policy.rdexpr evaluates to true.

edb_redaction_policy

The catalog edb_redaction_policy stores information of the redaction policies for tables.

ColumnTypeReferencesDescription
oidoidRow identifier (hidden attribute, must be explicitly selected).
rdnamenameThe name of the data redaction policy
rdrelidoidpg_class.oidThe table to which the data redaction policy applies.
rdenablebooleanIs the data redaction policy enabled?
rdexprpg_node_treeThe data redaction policy expression.
Note

The data redaction policy applies for the table if it is enabled and the expression ever evaluated true.

edb_resource_group

The edb_resource_group table contains one row for each resource group created with the CREATE RESOURCE GROUP command.

ColumnTypeModifiersDescription
rgrpname"name"not nullThe name of the resource group.
rgrpcpuratelimitfloat8not nullMaximum CPU rate limit for a resource group. 0 means no limit.
rgrpdirtyratelimitfloat8not nullMaximum dirty rate limit for a resource group. 0 means no limit.

edb_variable

The edb_variable table contains one row for each package level variable (each variable declared within a package).

ColumnTypeModifiersDescription
varname"name"not nullThe name of the variable.
varpackageoidnot nullThe OID of the pg_namespace row that stores the package.
vartypeoidnot nullThe OID of the pg_type row that defines the type of the variable.
varaccess"char"not null+ if the variable is visible outside of the package.

- if the variable is only visible within the package.

Note: Public variables are declared within the package header, private variables are declared within the package body.
varsrctextContains the source of the variable declaration, including any default value expressions for the variable.
varseqsmallintnot nullThe order in which the variable was declared in the package.

pg_synonym

The pg_synonym table contains one row for each synonym created with the CREATE SYNONYM command or CREATE PUBLIC SYNONYM command.

ColumnTypeModifiersDescription
synname"name"not nullThe name of the synonym.
synnamespaceoidnot nullReplaces synowner. Contains the OID of the pg_namespace row where the synonym is stored
synowneroidnot nullThe OID of the user that owns the synonym.
synobjschema"name"not nullThe schema in which the referenced object is defined.
synobjname"name"not nullThe name of the referenced object.
synlinktextThe (optional) name of the database link in which the referenced object is defined.

product_component_version

The product_component_version table contains information about feature compatibility, an application can query this table at installation or run time to verify that features used by the application are available with this deployment.

ColumnTypeDescription
productcharacter varying (74)The name of the product.
versioncharacter varying (74)The version number of the product.
statuscharacter varying (74)The status of the release.