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
CREATE VIEW statement to create a view.
CREATE VIEW myview AS SELECT * FROM products WHERE kind = 'food';
Delete a view
DROP VIEW statement to delete a view.
DROP VIEW myview;
For more information, visit Pivotal Greenplum documentation.