18.1. Creating an Analytical Schema #

Execute the following query:

  SELECT metastore.add_schema('schema_name');

Where schema_name is the unique analytical schema name.

Example 18.1. 

  SELECT metastore.add_schema('schema_example');

Once the query is executed, pgpro_metastore performs the following actions:

  • Verifies user privileges.

  • Creates a new entry in the pga_schema metadata table.