CREATE DIRECTORY
Description
Creates a directory. The directory defines an alias for a path in the server file system and is used to store data files used by users.
Precautions
- When enable_access_server_directory is set to off, only the initial user is allowed to create directory objects. When enable_access_server_directory is set to on, the user with the SYSADMIN permission and the user who inherits the gs_role_directory_create permission of the built-in role can create directory objects.
- By default, the user who creates a directory has the read and write permissions on the directory.
- The default owner of a directory is the user who creates the directory.
- A directory cannot be created for the following paths:
- The path contains special characters.
- The path is a relative path.
- The following validity check is performed during directory creation:
- Check whether the path exists in the OS. If it does not exist, a message is displayed, indicating the potential risks.
- Check whether the database initial user omm has the R/W/X permissions for the OS path. If the user does not have all the permissions, a message is displayed, indicating the potential risks.
- Ensure that the path is the same on all the database nodes. Otherwise, the path may fail to be found on some nodes when the directory is used.
Syntax
CREATE [OR REPLACE] DIRECTORY directory_name AS 'path_name';
Parameters
- directory_name
Specifies the name of a directory.
Value range: a string. It must comply with the naming convention.
- path_name
Specifies the OS path for which a directory is to be created.
Value range: a valid OS path
Examples
-- Create a directory.
gaussdb=# CREATE OR REPLACE DIRECTORY dir as '/tmp/';
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot