Postgres hasn't implemented an equivalent to INSERT OR REPLACE . From the ON CONFLICT docs (emphasis mine):. It can be either DO NOTHING, or a DO UPDATE ... ... <看更多>

When doing upserts in PostgreSQL 9.5+ you must refer to the excluded data (that which failed to insert) by the alias excluded . Also, the on conflict option ... ... <看更多>

We already support ON CONFLICT .. DO UPDATE .. WHERE as of #5637, but there's another possible WHERE clause that further specifies the ON ... ... <看更多>

Support PostgreSQL ON CONFLICT #578. https://www.postgresql.org/docs/current/sql-insert.html. I'm looking to write a query like; INSERT INTO table ("col", ... ... <看更多>