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

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