Help Center/GaussDB/Developer Guide(Distributed_V2.0-2.x)/System Catalogs and System Views/System Catalogs/PG_DIRECTORY
Updated on 2025-08-19 GMT+08:00
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 permissions of the built-in role gs_role_directory_create can create directory objects.
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. |
Parent topic:System Catalogs
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
