DROP DIRECTORY

Function

Deletes a directory.

Precautions

• When enable_access_server_directory is set to off, only the initial user is allowed to delete the directory object.
• When enable_access_server_directory is set to on, a user with the SYSADMIN permission, a directory object owner, a user granted with the DROP permission for a directory, or a user inherited from the built-in role gs_role_directory_drop can delete a directory object.

Syntax

1

DROP DIRECTORY [ IF EXISTS ] directory_name;

Parameters

• 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.
gaussdb=# CREATE OR REPLACE DIRECTORY  dir  as '/tmp/';

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

Helpful Links

CREATE DIRECTORY and ALTER DIRECTORY