SELECT [ ALL | DISTINCT ] expression [ AS name ] [, ...] INTO [TEMP] [ TABLE ] new_table ] [ FROM table [alias] [, ...] ] [ WHERE condition ] [ GROUP BY column [, ...] ] [ HAVING condition [, ...] ] [ { UNION [ALL] | INTERSECT | EXCEPT } select] [ ORDER BY column [ ASC | DESC ] [, ...] ] [ FOR UPDATE [OF class_name...]] [ LIMIT count [OFFSET|, count]]
SELECT INTO creates a new table from the results of a query. Typically, this query draws data from an existing table, but any SQL query is allowed.
SELECT INTO は問い合わせの結果から新しいテーブルを作成します。通常、 この問い合わせは既存のテーブルからデータを引き出すものになりますが、 どのようなSQL 問い合わせでも使用できます。
Note: CREATE TABLE AS is functionally equivalent to the SELECT INTO command.
CREATE TABLE AS は機能的にはSELECT INTO コマンドと同一です。