Creating a view in Greenplum
Note: Temporary views exist in a special schema, so a schema name may not be given when creating a temporary view. The name of the
view must be distinct from the name of any other view, table, sequence, or index in the same schema.
Creating a view
CREATE [OR REPLACE] [TEMP | TEMPORARY] VIEW name
[ ( column_name [, ...] ) ]
Dropping a view
DROP VIEW [IF EXISTS] name [, ...] [CASCADE | RESTRICT]