PostgreSQL从9.5之后就提供了原子的upsert语法: 不存在则插入,发生冲突可以update。...SELECT privilege on any column appearing within index_expression is required.
## 使用示例
创建表
CREATE TABLE...default" ) ;
当主键id冲突时,更新其他字段
INSERT INTO test.upsert_test(id, "name") VALUES(1, 'm'),(2, 'n'),(4..., 'c') ON conflict(id) DO UPDATE SET "name" = excluded.name;
did 冲突的主键
EXCLUDED 代指要插入的记录
当主键或者...unique key发生冲突时,什么都不做
INSERT INTO test.upsert_test(id, "name")
VALUES(1, 'm'),(2, 'n'),(4, 'c')
ON conflict