Analytical schemas associated with analytical tables or Postgres Pro views cannot be deleted.
Execute the following query:
SELECT metastore.remove_schema('schema_name');
Where schema_name is the name of the analytical
schema that is deleted.
Example 18.2.
SELECT metastore.remove_schema('schema_example');
Once the query is executed, pgpro_metastore performs the following actions:
Verifies user privileges.
Creates a new entry in the
pga_snapshot
metadata table and specifies for the analytical schema and all its associated
pgpro_metastore objects the
end_snapshot value in the
pga_schema
metadata table and other metadata tables.