PG_DIRECTORY
PG_DIRECTORY stores directory objects added by users. You can execute the CREATE DIRECTORY statement to add records to this system catalog. When enable_access_server_directory is set to off, only the initial user can create directory objects. When enable_access_server_directory is set to on, users with the SYSADMIN permission and users inheriting the built-in role permission gs_role_directory_create can create directory objects. Common users can access this system catalog only after being authorized.
| Name | Type | Description |
|---|---|---|
| oid | oid | Row identifier (hidden attribute, which must be specified) |
| dirname | name | Name of a directory object |
| owner | oid | Owner of a directory object |
| dirpath | text | Directory path. |
| diracl | aclitem[] | Access permissions. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
