1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
CREATE TEMP TABLE t1 AS (
SELECT something
FROM t2
);
CREATE TEMP TABLE t1 AS
SELECT something
FROM t2
;
CREATE TEMPORARY TABLE t1 AS
SELECT something
FROM t2
;
CREATE TABLE t1 AS (
SELECT something
FROM t2
);
CREATE TABLE t1 AS
SELECT something
FROM t2
;
CREATE TABLE IF NOT EXISTS t1 AS
SELECT something
FROM t2
;
CREATE TABLE t1 ON COMMIT DELETE ROWS AS
SELECT something
FROM t2
;
CREATE TABLE t1 ON COMMIT PRESERVE ROWS AS
SELECT something
FROM t2
;
CREATE TABLE t1 ON COMMIT DROP AS
SELECT something
FROM t2
;
CREATE TABLE t1 AS (
SELECT something
FROM t2
)
WITH NO DATA
;
CREATE TABLE t1 AS
SELECT something
FROM t2
WITH NO DATA
;
CREATE TABLE t1 AS (
SELECT something
FROM t2
)
WITH DATA
;
CREATE TABLE t1 AS
SELECT something
FROM t2
WITH DATA
;
CREATE UNLOGGED TABLE t1 AS
SELECT something
FROM t2
;
CREATE GLOBAL TEMP TABLE t1 AS
SELECT something
FROM t2
;
CREATE LOCAL TEMP TABLE t1 AS
SELECT something
FROM t2
;
CREATE TABLE t1 USING method AS
SELECT something
FROM t2
;
CREATE TABLE t1 WITHOUT OIDS AS
SELECT something
FROM t2
;
CREATE TABLE t1 (c1, c2, c3) AS VALUES
('val1', 'val2', 'val3'),
('val4', 'val5', 'val6')
;
CREATE TABLE t1 AS
TABLE t2
;
CREATE TABLE t1 AS
EXECUTE func()
;
CREATE TABLE t1 TABLESPACE ts AS
SELECT something
FROM t2
;
CREATE TABLE t1 WITH (val=70) AS
SELECT something
FROM t2
;
create temp table t1
with (autovacuum_enabled = true, toast_tuple_target = 123, vacuum_index_cleanup = false) as
select
column_1
, column_2
, column_3
from tablename;
create temp table a_new_table
with (appendoptimized = true, compresstype = zstd) as
select
column_1
, column_2
, column_3
from schema.tablename
group by 1, 2, 3;
|
