postgres 新增或者更新语句

INSERT INTO _fba_inventory (asin, store_id, total_qty)
VALUES (2, 2, 1)
ON CONFLICT (asin,store_id) DO UPDATE SET total_qty = 4,
                                          write_date=now();

-- 发现冲突后什么也不处理
INSERT INTO _fba_inventory (asin, store_id, total_qty)
VALUES (2, 2, 1)
ON CONFLICT (asin,store_id) DO nothing ;

postgres 新增或者更新语句

原文：https://www.cnblogs.com/qianxunman/p/14201930.html