http://www.postgresqltutorial.com/postgresql-views/

Creating PostgreSQL updatable views – gives you examples of creating updatable views that allow you to issue INSERT, UPDATE, and DELETE statement to update data in the base tables through the views.

Creating updatable views using the WITH CHECK OPTION clause – shows you how to use the WITH CHECK OPTION clause to check the view-defining condition when you make a change to the base table through the view. We also discuss the scope of check including LOCAL and CASCADED.

Create Rule的详细介绍：（9.3版本以上支持）

https://www.postgresql.org/docs/10/static/sql-createrule.html

CREATE [ OR REPLACE ] RULE name AS ON event
    TO table_name [ WHERE condition ]
    DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) }

where event can be one of:

    SELECT | INSERT | UPDATE | DELETE

CHECK OPTION信息介绍：（9.3版本以上支持）

https://www.postgresql.org/docs/current/static/sql-createview.html

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

转载于:https://www.cnblogs.com/aoyihuashao/p/8952005.html