Upsert Postgres
Insert or update.
- Snippet
- Database admin
- 5 blanks to fill
INSERT INTO Table (Key, Column) VALUES (Key value, Value) ON CONFLICT (Key) DO UPDATE SET Column = EXCLUDED.Column;
Orange words are blanks you have not filled yet. Press ⌘ Return to copy.
About this template
Insert or update.
- Category
- Code snippets
- Pack
- Database admin
- Type
- Snippet, a short message
- Asks for
- Table, Key, Column, Key value, Value
Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.
Template source
The template as written, with its blanks in double braces, such as {{Name}}.
INSERT INTO {{Table}} ({{Key}}, {{Column}})
VALUES ({{Key value}}, {{Value}})
ON CONFLICT ({{Key}}) DO UPDATE SET {{Column}} = EXCLUDED.{{Column}};