CREATE TABLE AS
目录
CREATE TABLE AS
NAMESYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES 注æ
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·
NAME
CREATE TABLE AS - ä»ä¸æ¡æ¥è¯¢çç»æä¸å建ä¸ä¸ªæ°è¡¨
SYNOPSIS
CREATE [ [
GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE
table_name [ (column_name [, ...] ) ]
AS query
DESCRIPTION æè¿°
CREATE TABLE AS å建ä¸ä¸ªè¡¨å¹¶ä¸ç¨æ¥èª SELECT å½ä»¤è®¡ç®åºæ¥çæ°æ®å¡«å该表ã 该表çå段å SELECT è¾åºå段çåå- åç±»åç¸å³ã ï¼åªä¸è¿ä½ å¯ä»¥éè¿æç¡®å°ç»åºä¸ä¸ªå段ååå表æ¥è¦ç SELECT çå- 段åï¼ã
CREATE TABLE AS åå建è§å¾æç¹è±¡ï¼ ä¸è¿ä¸¤èä¹é´å®å¨æ¯ææ¯è¾å¤§å·®å¼ï¼å®å建ä¸ä¸ªæ°è¡¨å¹¶ä¸åªå¯¹ SELECT 计ç®ä¸æ¬¡æ¥å¡«åè¿ä¸ªæ°è¡¨ã æ°è¡¨ä¸è½è·è¸ª SELECT çæºè¡¨éååçååã ç¸æ¯ä¹ä¸ï¼æ¯æ¬¡åæ¥è¯¢çæ¶åï¼è§å¾é½éæ°è®¡ç®å®ä¹å®ç SELECT è¯å¥ã
PARAMETERS åæ°
TEMPORARY or TEMP
å¦æ声æäºè¿ä¸ªé项ï¼å该表ä½ä¸ºä¸´æ¶è¡¨å建ã åé CREATE TABLE [create_table(7)] è·åç»èã
table_name
è¦å建ç表åï¼å¯ä»¥æ¯ç¨æ¨¡å¼ä¿®é¥°çï¼ã
column_name
å段çå称ãå¦æ没ææä¾å段ååï¼é£ä¹å°±ä»æ¥è¯¢çè¾åºå段åä¸è·åã å¦æ表æ¯ä¸ä¸ª EXECUTE å½ä»¤å建çï¼ é£ä¹å½åå°±ä¸è½å£°æå段åå表ã
|
query |
ä¸ä¸ªæ¥è¯¢è¯å¥ï¼ä¹å°±æ¯ä¸æ¡ SELECT å½ä»¤æèä¸æ¡è¿è¡åå¤å¥½ç SELECT å½ä»¤ç EXECUTE å½ä»¤ï¼ï¼è¯·åå«åè SELECT [select(7)] æè EXECUTE [execute(l)] è·åå¯ä»¥ä½¿ç¨çè¯æ³çæè¿°ã
NOTES 注æ
è¿æ¡å½ä»¤ä»åè½ä¸çæäº SELECT INTO [select_into(7)]ï¼ ä½æ¯æ们æ´å»ºè®®ä½ ç¨è¿ä¸ªå½ä»¤ï¼å 为å®ä¸å¤ªå¯è½å SELECT ... INTO è¯- æ³çå¶å®æ¹é¢ç使ç¨æ··æ·ã
COMPATIBILITY å¼å®¹æ§
è¿æ¡å½ä»¤æ¯æ ¹æ® Oracle çä¸ä¸ªç¹æ§å¶ä½çã å¨ SQL æ åä¸æ²¡æåè½ç¸ç- çå½ä»¤ãä¸è¿ï¼ æ CREATE TABLE å INSERT ... SELECT ç»åèµ·æ¥å¯ä»¥éè¿ç¥å¾®å¤ä¸äºçå·¥ä½å®æåæ ·çäºæã
SEE ALSO åè§
CREATE TABLE [create_table(7)], CREATE VIEW [create_view(l)], EXECUTE [execute(l)], SELECT [select(l)], SELECT INTO [select_into(l)]
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh