Postgres support (DML) #47
Description
DML
- INSERT INTO
- WITH clause
-
AS alias -
OVERRIDING { SYSTEM | USER } VALUE -
DEFAULT VALUES -
DEFAULTin values list - insert a query
-
ON CONFLICTclause-
ON CONFLICT (col1, col2, ...) -
ON CONFLICT ((expr1), (expr2)) -
ON CONFLICT (func1(), func2()) -
ON CONFLICT (col1 {ASC | DESC}) -
ON CONFLICT (col1 NULLS {FIRST | LAST}) -
ON CONFLICT (col1 COLLATE myCollation) -
ON CONFLICT (col1 opclass)where opclass is an identifier likeint4_ops -
ON CONFLICT (col1) WHERE index_predicate -
ON CONFLICT ON CONSTRAINT name -
... DO NOTHING -
... UPDATE SET col1 = expr, col2 = DEFAULT -
... UPDATE SET (col1, col2) = (expr, DEFAULT) -
... UPDATE SET (col1, col2) = ROW (expr, DEFAULT) -
... UPDATE SET ... WHERE condition
-
-
RETURNING col1, col2, ... -
RETURNING * -
RETURNING output_expression [[AS] output_name]
- UPDATE
- WITH clause
-
UPDATE [ONLY] tablename -
tablename * -
[AS] alias -
SET col = DEFAULT - multi-column assignment:
(col1, col2) = (1, 2) -
SET (col1, col2) = ROW (expr1, expr2) -
SET (col1, col2) = ROW (DEFAULT, ...) - sub-select assignment:
col = (SELECT ...) -
FROM -
WHERE -
WHERE CURRENT OF cursor -
RETURNING * -
RETURNING output_expression [[AS] output_name]
- DELETE FROM
- WITH clause
-
ONLY -
tablename * -
[AS] alias -
USING from_item, ... -
WHERE -
WHERE CURRENT OF cursor -
RETURNING * -
RETURNING output_expression [[AS] output_name]
- MERGE INTO
- WITH clause
-
MERGE INTO [ONLY] -
tablename * -
AS alias -
USING [ONLY] tablename [*] ON join_condition -
USING (query) [[AS] alias] ON join_condition -
WHEN [NOT] MATCHED [AND condition] THEN action - merge actions:
-
DO NOTHING -
DELETE -
UPDATE SET ... -
INSERT [( column_name [, ...] )] VALUES ( ... ) -
INSERT ... DEFAULT VALUES -
INSERT OVERRIDING { SYSTEM | USER } VALUE ...
-
- TRUNCATE
-
TRUNCATE [TABLE] -
TRUNCATE [ONLY] - multi-table truncate
-
tablename * -
RESTART IDENTITY | CONTINUE IDENTITY -
CASCADE | RESTRICT
-