DROP DIRECTORY

Function

DROP DIRECTORY deletes a directory.

Precautions

When enable_access_server_directory is set to off, only the initial user is allowed to delete directory objects. When enable_access_server_directory is set to on, a user with the SYSADMIN permission, the owner of the directory object, a user who is granted with the DROP permission of the directory, or a user who inherits the gs_role_directory_drop permission of the built-in role can delete directory objects.

Syntax

1

DROP DIRECTORY [ IF EXISTS ] directory_name;

Parameter Description

• directory_name

  Specifies the name of the directory to be deleted.

  Value range: an existing directory name

Examples

1
2
3
4
5

-- Create a directory.
openGauss=# CREATE OR REPLACE DIRECTORY  dir  as '/tmp/';

-- Delete a foreign table.
openGauss=# DROP DIRECTORY dir;

Helpful Links

CREATE DIRECTORY and ALTER DIRECTORY