NAME CREATE_VIEW - define a new view SYNOPSIS CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW ... name [ ( column_name [, ...] ) ] [ WITH ( view_option_name [= view_o…NAME ALTER_VIEW - change the definition of a view SYNOPSIS ALTER VIEW [ IF EXISTS ] name ... COLUMN ] column_name SET DEFAULT expression ALTER VIEW [ IF EXISTS ] name ALTER [ COLUM…NAME CREATE_MATERIALIZED_VIEW - define a new materialized view SYNOPSIS CREATE MATERIALIZED VIEW ... query [ WITH [ NO ] DATA ] DESCRIPTION CREATE MATERIALIZED VIEW defines a mater…NAME ALTER_MATERIALIZED_VIEW - change the definition of a materialized view SYNOPSIS ALTER MATERIALIZED VIEW ... EXISTS ] name action [, ... ] ALTER MATERIALIZED VIEW name [ NO ] D…NAME REFRESH_MATERIALIZED_VIEW - replace the contents of a materialized view SYNOPSIS REFRESH MATERIALIZED VIEW ... name [ WITH [ NO ] DATA ] DESCRIPTION REFRESH MATERIALIZED VIEW …NAME DROP_MATERIALIZED_VIEW - remove a materialized view SYNOPSIS DROP MATERIALIZED VIEW [ IF EXISTS ] name ... CASCADE | RESTRICT ] DESCRIPTION DROP MATERIALIZED VIEW drops an exi…NAME DROP_VIEW - remove a view SYNOPSIS DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DESCRIPTION ... DROP VIEW drops an existing view. To execute this command you mu…rule applying to a specified table or view. CREATE OR REPLACE RULE will either create ... command defines the visible contents of the view. (The view itself is basically a dummywill be associated with the specified table, view, or foreign table and will execute ... inserts, updates or deletes on a view). If the trigger fires before or insteadalways released at transaction end.) When a view is locked, all relations appearing ... view definition query are also locked recursively with the same lock mode. When acquiring lo…WITH - retrieve rows from a table or view SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] SELECT ... schema-qualified) of an existing table or view. If ONLY is specified before …name | LARGE OBJECT large_object_oid | MATERIALIZED VIEW object_name | OPERATOR operator_name ( left_type ... name ON table_name | TYPE object_name | VIEW object_name } IS { string…tables which are referenced by a view will use the view owner's rights ... policies which apply to the view owner, except if the view is defined usingtarget table is a materialized view, foreign table, or if it has any rules defined ... schema-qualified) of the target table or view to merge into. If ONLY is specifiedfour masks is as follows: view The attributes of the key may be read. This ... keys for which the reading thread has view permission, providing various information about eachlist, VACUUM processes every table and materialized view in the current database that the current ... qualified) of a specific table or materialized view to vacuum. If the specifie…table or a materialized view. Indexes are primarily used to enhance database performance (though inappropriate ... other relation (table, sequence, index, view, materialized view, …schema. Currently, only CREATE TABLE , CREATE VIEW , CREATE INDEX , CREATE SEQUENCE , CREATE TRIGGER and GRANT ... schema and create a table and view within it: CREATE SCHEMA holly…bears some resemblance to creating a view, but it is really quite different: it creates ... tables of the query. In contrast, a view re-evaluates its defining SELECT statement when…drawn between processes and tasks . In this view, a process can consist of multiple tasks ... results is multiple mount points providing a view of the same hierarchy. Note that