QqkkHrkT

1WITH w AS (
2  SELECT *
3  FROM ( VALUES (1) ) AS t(x)
4)
5SELECT *
6INTO foo
7FROM w;
8	
9WITH w AS (
10  SELECT *
11  FROM ( VALUES (1) ) AS t(x)
12)
13CREATE TABLE foo AS
14SELECT * FROM w;
15	
16ERROR:  syntax error at or near "CREATE"
17LINE 5: CREATE TABLE foo AS
18	
19CREATE TABLE foo AS
20WITH w AS (
21  SELECT *
22  FROM ( VALUES (1) ) AS t(x)
23)
24SELECT * FROM w;
25	
26CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name
27    [ (column_name [, ...] ) ]
28    [ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
29    [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
30    [ TABLESPACE tablespace_name ]
31    AS query
32    [ WITH [ NO ] DATA ]
33	
34CREATE TABLE foo
35WITH (fillfactor = 100)
36AS
37  WITH w AS (
38    SELECT *
39    FROM ( VALUES (1) ) AS t(x)
40  )
41  SELECT * FROM w
42WITH NO DATA;
43	
44TABLE foo;
45 x 
46---
47(0 rows)