19.1. Creating a Shared Directory #
Execute the following query:
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.
Example 19.1.
SELECT metastore.add_folder('shared_directory_example', 'storage_example', '/relative_path');
Once the query is executed, pgpro_metastore performs the following actions:
Verifies user privileges.
Ensures that the specified path leads to an existing shared directory.
Creates a new entry in the
pga_foldermetadata table.