28.2. Deleting a Shared Directory (metastore.remove_folder) #

Required privileges: Postgres Pro AXE administrator only. For more information about stored procedures and privileges, refer to Section 22.1.

Execute the following command:

  SELECT metastore.remove_folder('shared_directory_name');

Where shared_directory_name is the name of the shared directory to delete.

Postgres Pro AXE performs the following actions:

  1. Verifies input parameters and user privileges.

  2. Creates a new entry in the pga_snapshot metadata table and sets the end_snapshot value for the shared directory in the pga_folder metadata table.

Example 28.2. Executing the metastore.remove_folder stored procedure

  SELECT metastore.remove_folder('shared_directory_example');