Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       CREATE VIEW -

SYNOPSIS

       CREATE [ OR REPLACE ] VIEW name [ ( column_name [, ...] ) ] AS query

DESCRIPTION

       CREATE VIEW   ON SELECT

       CREATE OR REPLACE VIEW

        CREATE VIEW myschema.myview ...

PARAMETERS

       name

       column_name

       query
                SELECT

                SELECT [select(7)]

NOTES

         CREATE RULE [create_rule(7)].

         DROP VIEW

       CREATE VIEW vista AS SELECT 'Hello World';

         ?column? unknown

       CREATE VIEW vista AS SELECT text 'Hello World' AS hello;

EXAMPLES

       CREATE VIEW comedies AS
           SELECT *
           FROM films
           WHERE kind = 'Comedy';

COMPATIBILITY

        SQL  CREATE VIEW

       CREATE VIEW name [ ( column [, ...] ) ]
           AS query
           [ WITH [ CASCADE | LOCAL ] CHECK OPTION ]

        SQL

       CHECK OPTION
                INSERTUPDATE

       LOCAL

       CASCADE
                 CASCADE  LOCAL  CASCADE

       CREATE OR REPLACE VIEW  PostgreSQL

       Postgresql  <laser@pgsqldb.org>