metastore.remove_storage) #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_storage('storage_name');
Where storage_name is the name of the storage
to delete.
Postgres Pro AXE performs the following actions:
Verifies input parameters and user privileges.
Creates a new entry in the
pga_snapshot
metadata table and sets the
end_snapshot value for the storage in the
pga_storage
metadata table.
Sets the end_snapshot value for
entries associated with the storage in other
metadata tables.
Example 24.3. Executing the metastore.remove_storage stored procedure
SELECT metastore.remove_storage('storage_example');