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.
Example:
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.
Example:
DROP VIEW myview;
References
For more information, visit Pivotal Greenplum documentation.