Help Center/ GaussDB/ Developer Guide(Centralized_3.x)/ System Catalogs and System Views/ System Catalogs/ PG_DIRECTORY

Updated on 2024-05-07 GMT+08:00

View PDF

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.

**Table 1** PG_DIRECTORY columns
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

Previous topic: PG_DESCRIPTION

Next topic: PG_ENUM

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.