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]



Comments