System catalog tables v15
The following system catalog tables contain definitions of database objects. The layout of the system tables is subject to change. If you're writing an application that depends on information stored in the system tables, we recommend using an existing catalog view or creating 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 path name 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 in 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 allows access only to paths that the database administrator has granted access to using a CREATE DIRECTORY command.
| Column | Type | Modifiers | Description |
|---|---|---|---|
dirname | "name" | not null | The name of the alias. |
dirowner | oid | not null | The OID of the user that owns the alias. |
dirpath | text | The directory name to which access is granted. | |
diracl | aclitem[] | The access control list that determines the users that can 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.
| Column | Type | Modifiers | Description |
|---|---|---|---|
group_name | "name" | Name of the resource group. | |
active_processes | integer | Number of currently active processes in the resource group. | |
cpu_rate_limit | float8 | Maximum CPU rate limit for the resource group. 0 means no limit. | |
per_process_cpu_rate_limit | float8 | Maximum CPU rate limit per currently active process in the resource group. | |
dirty_rate_limit | float8 | Maximum dirty rate limit for a resource group. 0 means no limit. | |
per_process_dirty_rate_limit | float8 | Maximum dirty rate limit per currently active process in the resource group. |
edb_policy
The edb_policy table contains one row for each policy.
| Column | Type | Modifiers | Description |
|---|---|---|---|
policyname | name | not null | The policy name. |
policygroup | oid | not null | Currently unused. |
policyobject | oid | not null | The OID of the table secured by this policy (the object_schema plus the object_name). |
policykind | char | not null | The kind of object secured by this policy: 'r' for a table 'v' for a view = for a synonym Currently always 'r'. |
policyproc | oid | not null | The OID of the policy function (function_schema plus policy_function). |
policyinsert | boolean | not null | True if the policy is enforced by INSERT statements. |
policyselect | boolean | not null | True if the policy is enforced by SELECT statements. |
policydelete | boolean | not null | True if the policy is enforced by DELETE statements. |
policyupdate | boolean | not null | True if the policy is enforced by UPDATE statements. |
policyindex | boolean | not null | Currently unused. |
policyenabled | boolean | not null | True if the policy is enabled. |
policyupdatecheck | boolean | not null | True if rows updated by an UPDATE statement must satisfy the policy. |
policystatic | boolean | not null | Currently unused. |
policytype | integer | not null | Currently unused. |
policyopts | integer | not null | Currently unused. |
policyseccols | int2vector | not null | The 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 in a cluster.
| Column | Type | References | Description |
|---|---|---|---|
oid | oid | Row identifier (hidden attribute, must be explicitly selected). | |
prfname | name | The name of the profile. | |
prffailedloginattempts | integer | The number of failed login attempts allowed by the profile. -1 indicates to use the value from the default profile. -2 indicates no limit on failed login attempts. | |
prfpasswordlocktime | integer | The password lock time associated with the profile, in seconds. -1 indicates to use the value from the default profile. -2 indicates to lock the account permanently. | |
prfpasswordlifetime | integer | The password life time associated with the profile, in seconds. -1 indicates to use the value from the default profile. -2 indicates that the password never expires. | |
prfpasswordgracetime | integer | The password grace time associated with the profile, in seconds. -1 indicates to use the value from the default profile. -2 indicates that the password never expires. | |
prfpasswordreusetime | integer | The number of seconds that a user must wait before reusing a password. -1 indicates to use the value from the default profile. -2 indicates that the old passwords can never be reused. | |
prfpasswordreusemax | integer | The number of password changes that must occur before a password can be reused. -1 indicates to use the value from the default profile. -2 indicates that the old passwords can never be reused. | |
prfpasswordverifyfuncdb | oid | pg_database.oid | The OID of the database in which the password verify function exists. |
prfpasswordverifyfunc | oid | pg_proc.oid | The 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.
| Column | Type | References | Description |
|---|---|---|---|
oid | oid | Row identifier (hidden attribute, must be explicitly selected). | |
rdpolicyid | oid | edb_redaction_policy.oid | The data redaction policy applies to the described column. |
rdrelid | oid | pg_class.oid | The table that the described column belongs to. |
rdattnum | int2 | pg_attribute.attnum | The number of the described column. |
rdscope | int2 | The redaction scope: 1 = query, 2 = top_tlist, 4 = top_tlist_or_error | |
rdexception | int2 | The redaction exception: 8 = none, 16 = equal, 32 = leakproof | |
rdfuncexpr | pg_node_tree | Data 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.
| Column | Type | References | Description |
|---|---|---|---|
oid | oid | Row identifier (hidden attribute, must be explicitly selected). | |
rdname | name | The name of the data redaction policy | |
rdrelid | oid | pg_class.oid | The table to which the data redaction policy applies. |
rdenable | boolean | Is the data redaction policy enabled? | |
rdexpr | pg_node_tree | The data redaction policy expression. |
Note
The data redaction policy applies for the table if it's enabled and the expression ever evaluated to true.
edb_resource_group
The edb_resource_group table contains one row for each resource group created with the CREATE RESOURCE GROUP command.
| Column | Type | Modifiers | Description |
|---|---|---|---|
rgrpname | "name" | not null | Name of the resource group. |
rgrpcpuratelimit | float8 | not null | Maximum CPU rate limit for a resource group. 0 means no limit. |
rgrpdirtyratelimit | float8 | not null | Maximum 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, that is, each variable declared in a package.
| Column | Type | Modifiers | Description |
|---|---|---|---|
varname | "name" | not null | The name of the variable. |
varpackage | oid | not null | The OID of the pg_namespace row that stores the package. |
vartype | oid | not null | The 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 visible only in the package.Note: Public variables are declared in the package header; private variables are declared in the package body. |
varsrc | text | Contains the source of the variable declaration, including any default value expressions for the variable. | |
varseq | smallint | not null | The 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.
| Column | Type | Modifiers | Description |
|---|---|---|---|
synname | "name" | not null | The name of the synonym. |
synnamespace | oid | not null | Replaces synowner. Contains the OID of the pg_namespace row where the synonym is stored. |
synowner | oid | not null | The OID of the user that owns the synonym. |
synobjschema | "name" | not null | The schema in which the referenced object is defined. |
synobjname | "name" | not null | The name of the referenced object. |
synlink | text | The 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 runtime to verify that features used by the application are available with this deployment.
| Column | Type | Description |
|---|---|---|
product | character varying (74) | The name of the product. |
version | character varying (74) | The version number of the product. |
status | character varying (74) | The status of the release. |