CREATE VIEW

中文man手册

目录

NAME CREATE VIEW
SYNOPSIS .sp .nf CREATE [ OR REPLACE ] VIEW
DESCRIPTION 描述
PARAMETERS 参数
NOTES 注意
EXAMPLES 例子
COMPATIBILITY 兼容性
译者
跋

CREATE VIEW

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES æ³¨æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
è¯è
è·

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

è¿ä¸ªéé¡¹ç¨äºå¯æ´æ°è§å¾ã ææå¯¹è§å¾çINSERTåUPDATEé½è¦ç»è¿è§å¾å®ä¹æ¡ä»¶çæ ¡éªã ï¼ä¹å°±æ¯è¯´ï¼æ°æ°æ®åºè¯¥å¯ä»¥éè¿è§å¾çå°ãï¼å¦ææ²¡æéè¿æ¡éªï¼æ´æ°å°è¢«æç»ã

LOCAL

å¯¹è¿ä¸ªè§å¾è¿è¡å®æ´æ§æ£æ¥ã

CASCADE

å¯¹æ¤è§å¾åä»»ä½ç¸å³è§å¾è¿è¡å®æ´æ§æ£æ¥ã å¨æ¢æ²¡æå£°æ CASCADE ä¹æ²¡æå£°æ LOCAL æ¶ï¼åè®¾ä¸º CASCADEã

CREATE OR REPLACE VIEW æ¯ PostgreSQL çæ©å±ã

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æåé¡µè®¡åæä¾ã
ä¸æ man æåé¡µè®¡åï¼https://github.com/man-pages-zh/manpages-zh

↑