Define a new Schema in Greenplum CREATE SCHEMA schema_name [AUTHORIZATION username] [schema_element [ ... ]] CREATE SCHEMA AUTHORIZATION rolename [schema_element [ ... ]] ALTER SCHEMA name RENAME TO newname ALTER SCHEMA name OWNER TO newowner |
Getting Started with Greenplum Database Installing Greenplum DatabaseConfiguring Greenplum Database Securing your database Allowing Connections to Greenplum Database Securing Greenplum Database MPP Data Models Greenplum Database Quick Facts Gpfdist Set Database Environment Schema Development Migrating to Greenplum Oracle to Greenplum PostgreSQL to Greenplum Monitoring and Maintenance Reporting Greenplum database performance tuning Best practice Tuning the environment Tuning configuration parameters Tuning SQL Tuning data models |
Creating a schema in greenplum
|