System Catalog Tables v11

Suggest edits

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.

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 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.

Column	Type	Description
`group_name`	`"name"`	The 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 within 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 that the value from the default profile should be used. -2 indicates no limit on failed login attempts.
`prfpasswordlocktime`	`integer`		The 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.
`prfpasswordlifetime`	`integer`		The 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.
`prfpasswordgracetime`	`integer`		The 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.
`prfpasswordreusetime`	`integer`		The 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.
`prfpasswordreusemax`	`integer`		The 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.
`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 will be 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 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.

Column	Type	Modifiers	Description
`rgrpname`	`"name"`	`not null`	The 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 (each variable declared within 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 only visible within the package. Note: Public variables are declared within the package header, private variables are declared within 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 run time 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.

← Prev

Advanced Server Keywords