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
|
INSERT INTO foo (bar) VALUES(current_timestamp);
INSERT INTO foo (bar, baz) VALUES(1, 2), (3, 4);
INSERT INTO foo (bar, baz) VALUES(1 + 1, 2), (3, 4);
INSERT INTO foo (bar) VALUES(DEFAULT);
INSERT INTO distributors AS d (did, dname) VALUES (8, 'Anvil Distribution');
INSERT INTO test (id, col1) OVERRIDING SYSTEM VALUE VALUES (1, 'val');
INSERT INTO test (id, col1) OVERRIDING USER VALUE VALUES (1, 'val');
INSERT INTO foo (bar) DEFAULT VALUES;
INSERT INTO films SELECT * FROM tmp_films WHERE date_prod < '2004-05-07';
INSERT INTO foo (bar) VALUES(current_timestamp)
RETURNING *;
INSERT INTO foo (bar) VALUES(current_timestamp)
RETURNING bar;
INSERT INTO foo (bar) VALUES(current_timestamp)
RETURNING bar AS some_alias;
INSERT INTO foo (bar, baz) VALUES(1, 2)
RETURNING bar, baz;
INSERT INTO foo (bar, baz) VALUES(1, 2)
RETURNING bar AS alias1, baz AS alias2;
INSERT INTO foo (bar, baz) VALUES (1, 'var')
ON CONFLICT (bar) DO UPDATE SET baz = EXCLUDED.baz;
INSERT INTO foo (bar, baz) VALUES (1, 'var')
ON CONFLICT (bar) DO NOTHING;
INSERT INTO foo AS f (bar, baz) VALUES (1, 'var')
ON CONFLICT (bar) DO UPDATE SET baz = EXCLUDED.baz || ' (formerly ' || f.baz || ')'
WHERE f.zipcode != '21201';
INSERT INTO foo (bar, baz) VALUES (1, 'var')
ON CONFLICT ON CONSTRAINT foo_pkey DO NOTHING;
INSERT INTO foo (bar, baz) VALUES (1, 'var')
ON CONFLICT (bar) WHERE is_active DO NOTHING;
INSERT INTO foo (bar, baz) VALUES (1, 'var')
ON CONFLICT (bar) DO UPDATE SET (baz) = (SELECT baz FROM foobar WHERE bar = 1);
INSERT INTO megatable (megacolumn)
SELECT * FROM (
VALUES ( 'megavalue' )
) AS tmp (megacolumn)
WHERE NOT EXISTS (
SELECT FROM megatable AS mt
WHERE mt.megacolumn = tmp.megacolumn
)
ON CONFLICT DO NOTHING;
INSERT INTO abc (foo, bar)
SELECT foo, bar FROM baz
RETURNING quux
;
INSERT INTO tbl_a (
val1
, val2
)
SELECT val1
, val2
FROM tbl_2
ON CONFLICT (
val1
, COALESCE(val2, '')
)
DO NOTHING;
INSERT INTO prompt_variants (
test,
test2
)
SELECT
test,
test2
RETURNING
test,
test2;
INSERT INTO
baz (state, state_changed_at, instance_id)
SELECT
1, 2, 3
ON CONFLICT (instance_id) DO UPDATE
SET
state = foo,
state_changed_at = bar;
|
