This page summarizes the INSERT ... ON CONFLICT UPDATE patch. This feature is popularly known as "UPSERT". The patch has been committed [1], and will appear in PostgreSQL 9.5. This Wiki page was only maintained until a few weeks before commit, where the patch further evolved in some minor aspects (most notably, the syntax became ON CONFLICT DO UPDATE/NOTHING). It is now only of historic interest.
{{#tags}}- {{label}}
{{/tags}}