PostgreSQL的upsert实例操作(insert on conflict do)

建表语句：

DROP TABLE IF EXISTS “goods”;
CREATE TABLE “goods” (
“store_cd” int4 NOT NULL,
“good_cd” varchar(50) COLLATE “pg_catalog”.”default” NOT NULL,
“name” varchar(255) COLLATE “pg_catalog”.”default”
);

INSERT INTO “goods” VALUES (101, ‘1’, ‘张三’);
INSERT INTO “goods” VALUES (102, ‘2’, ‘李四’);
INSERT INTO “goods” VALUES (103, ‘3’, ‘王五’);

ALTER TABLE “goods” ADD CONSTRAINT “pr_cd_key” PRIMARY KEY (“store_cd”, “good_cd”);