INSERT
Insert documents
Synopsis
INSERT statement
Diagram(
Stack(
Sequence("INSERT", "INTO", "table-name"),
Choice(0, Link("values-clause"), Link("select-stmt", "select#select-stmt")),
Optional(Link("conflict-clause"), "skip"),
Optional(Link("returning-clause"), "skip")
)
);
VALUES clause
Diagram(
Stack(
Choice(
0,
Sequence(
Optional(Sequence("(", OneOrMore("field-name", ","), ")"), "skip"),
"VALUES",
OneOrMore(
Sequence(
"(",
OneOrMore(Link("expr", "/docs/essentials/expressions"), ","),
")"
),
","
)
),
Sequence(
"VALUES",
OneOrMore(
Link(
"document-literal",
"/docs/essentials/expressions#document-literal"
),
","
)
)
)
)
);
Conflict clause
Diagram(
Sequence(
"ON",
"CONFLICT",
Choice(
0,
"IGNORE",
"REPLACE",
Sequence("DO", "NOTHING"),
Sequence("DO", "REPLACE")
)
)
);
RETURNING clause
Diagram(
Sequence(
"RETURNING",
Link("expr", "/docs/essentials/expressions"),
Optional(Sequence("AS", "alias"), "skip")
)
);
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.
Last modified July 2, 2022: Update insert doc (fa09599)