Creating and Managing Views in Greenplum

Views are a way to save frequently used or complex queries and then access them in a SELECT statement as if they were a table. A view is not physically materialized on disk as is a table. The query is instead ran as a subquery whenever the view is accessed.

Creating Views

The CREATE VIEW command defines a view of a query. For example:
CREATE VIEW comedies AS SELECT * FROM films WHERE kind = 'comedy';

Note that currently views ignore ORDER BY or SORT operations stored in the view.

Dropping Views

The DROP VIEW command removes a view. For example:
DROP VIEW topten;