View synopsis

In the view synopsis shown below, the CREATE VIEW statement is used to create a view, if the REPLACE keyword is used, the view will be replaced if it already exists. View attribute names can be given explicitly, or they can be inherited from the SELECT statement:

CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ]
    [ WITH ( view_option_name [= view_option_value] [, ... ] ) ]
    AS query
    [ WITH [ CASCADED | LOCAL ] CHECK OPTION ]

The synopsis of materialized views differs from the view synopsis. Please refer to the Materialized views section for the materialized view synopsis. 

The following example shows how to create a view that lists only the user information without the password. This might be useful for implementing data authorization to restrict applications from accessing the password. Note that the...