metastore.add_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.add_folder('shared_directory_name', 'storage_name', 'path_to_the_shared_directory');
Where:
shared_directory_name: The unique shared
directory name.
storage_name: The name of the
storage where
the shared directory is created.
path_to_the_shared_directory: The path to the
shared directory relative to the root directory of the storage.
The specified shared directory must exist in the storage, but not in the
pga_folder
metadata table for this storage.
Postgres Pro AXE performs the following actions:
Verifies input parameters and user privileges.
Ensures that the specified path leads to an existing shared directory.
Creates a new entry in the
pga_folder
metadata table.
Example 28.1. Executing the metastore.add_folder stored procedure
SELECT metastore.add_folder('shared_directory_example', 'storage_example', '/relative_path');