System Catalog Tables v11
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.
dual
dual is a single-row, single-column table that is provided for compatibility with Oracle databases only.
| Column | Type | Modifiers | Description |
|---|---|---|---|
dummy | VARCHAR2(1) | Provided for compatibility only. |
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_password_history
The edb_password_history table contains one row for each password change. The table is shared across all databases within a cluster.
| Column | Type | References | Description |
|---|---|---|---|
passhistroleid | oid | pg_authid.oid | The ID of a role. |
passhistpassword | text | Role password in md5 encrypted form. | |
passhistpasswordsetat | timestamptz | The time the password was set. |
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. | |
prfpasswordallowhashed | integer | The password allow hashed parameter specifies whether an encrypted password to be allowed for use or not. The possible values can be true/on/yes/1, false/off/no/0, and DEFAULT. | |
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_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. |