DROP DIRECTORY

Description

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 the DROP permission for a directory, or a user who inherits permissions 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

• IF EXISTS

  Does not report an error if the specified directory object does not exist. A notice is issued in this case.

Examples

1
2
3
4
5

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

-- Delete the directory object.
gaussdb=# DROP DIRECTORY dir;

Helpful Links

CREATE DIRECTORY and ALTER DIRECTORY