23.1. Creating an Analytical Schema (metastore.add_schema) #
Required privileges: Postgres Pro AXE administrator only. For more information about stored procedures and privileges, refer to Section 18.1.
Execute the following command on the Postgres Pro AXE server:
SELECT metastore.add_schema('schema_name');
Where schema_name is the unique analytical schema name.
Postgres Pro AXE performs the following actions:
Checks input parameters and user privileges.
Creates a new entry in the
pga_schemametadata table.
Example 23.1. Executing the metastore.add_schema Stored Procedure
SELECT metastore.add_schema('schema_example');