SELECT INTO

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES 注æ
COMPATIBILITY å¼å®¹æ§
è¯è
è·

---

NAME

SELECT INTO - ä»ä¸ä¸ªæ¥è¯¢çç»æä¸å建ä¸ä¸ªæ°è¡¨

SYNOPSIS

SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ AS output_name ] [, ...]
INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start ]
[ FOR UPDATE [ OF tablename [, ...] ] ]

DESCRIPTION æè¿°

SELECT INTO ä»ä¸ä¸ªæ¥è¯¢ç计ç®ç»æä¸å建ä¸ä¸ªæ°è¡¨ã æ°æ®å¹¶ä¸è¿åç»å®¢æ·ç«¯ï¼è¿ä¸ç¹åæ®éç SELECT ä¸åã æ°è¡¨çå段å·æå SELECT çè¾åºå段ç¸å³èï¼ç¸åï¼çåååæ°æ®ç±»åã

PARAMETERS åæ°

TEMPORARY æ TEMP

å¦æ声æäºè¿ä¸ªå³é®åï¼é£ä¹è¯¥è¡¨æ¯ä½ä¸ºä¸ä¸ªä¸´æ¶è¡¨å建çã 请åè CREATE TABLE [create_table(7)] è·åç»èã

new_table

è¦å建ç表ç表åï¼å¯ä»¥æ模å¼ä¿®é¥°ï¼ã

ææå¶å®è¾å¥çåé½å¨ SELECT [select(7)] ä¸æ详ç»æè¿°ã

NOTES 注æ

CREATE TABLE AS [create_table_as(7)] çä½ç¨å SELECT INTO ç¸åã æä»¬å»ºè®®ä½¿ç¨ CREATE TABLE AS è¯æ³ï¼ å ä¸º SELECT INTO ä¸æ¯æ åè¯æ³ã å®éä¸ï¼è¿ç§ç±»åç SELECT INTO æ¯ä¸è½å¨ ECPG æè PL/pgSQL ä¸ä½¿ç¨çï¼ å ä¸ºå®ä»¬å¯¹ INTO åå¥ç解éæ¯ä¸åçã

COMPATIBILITY å¼å®¹æ§

SQL æ åç¨ SELECT ... INTO 表示éåæ°å¼å°ä¸ä¸ªå®¿ä¸»ç¨åºçæ éåéä¸ï¼ èä¸æ¯å建ä¸ä¸ªæ°è¡¨ãè¿ç§ç¨æ³å®éä¸å°±æ¯å¨ ECPG ï¼åé Chapter 29ï¼åPL/pgSQL ï¼Chapter 35ï¼éçç¨éã PostgreSQL ç¨ SELECT INTO 代表å建表çæææ¯åå²åå ã å¨æ°ä»£ç éæ们æå¥½ä½¿ç¨ CREATE TABLE AS å®ç°è¿ä¸ªç®å°ã (CREATE TABLE AS ä¹ä¸æ¯æ åï¼ä½è³å°å®åºç°æ··æ·çæºä¼å°ä¸äºã)

è¯è

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

è·

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

---