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 [, ...] ) ]

AS query

Dropping a view

DROP VIEW [IF EXISTS] name [, ...] [CASCADE | RESTRICT]