Postgres: INSERT if does not exist already

by

Postgres 9.5 (released since 2016-01-07) offers an “upsert” command, also known as an ON CONFLICT clause to INSERT:

INSERT ... ON CONFLICT DO NOTHING/UPDATE

It solves many of the subtle problems you can run into when using concurrent operation, which some other answers propose.

More Related Contents:

  1. Insert, on duplicate update in PostgreSQL?
  2. How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
  3. Use multiple conflict_target in ON CONFLICT clause
  4. serial in postgres is being increased even though I added on conflict do nothing
  5. How to find out if an upsert was an update with PostgreSQL 9.5+ UPSERT?
  6. Differentiate inserted and updated rows in UPSERT using system columns
  7. Can I use return value of INSERT…RETURNING in another INSERT?
  8. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  9. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  10. How do you use variables in a simple PostgreSQL script?
  11. How to make “case-insensitive” query in Postgresql?
  12. Rownum in postgresql
  13. How to switch databases in psql?
  14. Postgresql: Scripting psql execution with password
  15. dynamic sql query in postgres
  16. Is there a timeout for idle PostgreSQL connections?
  17. How to make connection to Postgres via Node.js
  18. docker postgres pgadmin local connection
  19. Does a Postgres UNIQUE constraint imply an index?
  20. SELECT raises exception in PL/pgSQL function
  21. Heroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  22. Changing primary key int type to serial
  23. Return SETOF rows from PostgreSQL function
  24. Dynamically generate columns for crosstab in PostgreSQL
  25. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  26. PostgreSQL via SSH Tunnel
  27. How should I import data from CSV into a Postgres table using pgAdmin 3?
  28. PostgreSQL – set a default cell value according to another cell value
  29. How to include excluded rows in RETURNING from INSERT … ON CONFLICT
  30. How to escape question mark (?) character with Spring JpaRepository

Leave a Comment