This topic describes how to manage views for both simple and complex queries in AnalyticDB for PostgreSQL. Views are not stored on physical devices. Each view you access runs as a subquery.

Create a view

Execute a CREATE VIEW statement to create a view.

CREATE VIEW myview AS SELECT * FROM products WHERE kind = 'food';
Note Operations specified by ORDER BY and SORT clauses in a view are ignored.

Delete a view

Execute a DROP VIEW statement to delete a view.

DROP VIEW myview;


For more information, visit Pivotal Greenplum documentation.