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_folder
metadata table.