Postgresql:INSERT INTO ON CONSTRAINT pk_key_id do nothing

一、Postgresql在插入数据有主键或者唯一键冲突时，可以不做任何操作，也可以update

1. do nothing

INSERT INTO t_test(id,name) VALUES (10,‘Lily’) ON CONFLICT
ON CONSTRAINT pk_test_id
do nothing;

2. update

INSERT INTO t_test(id,name) VALUES ( 104,‘赵六’ ) ON CONFLICT
ON CONSTRAINT pk_test_id
DO UPDATE SET NAME = ‘更新’ WHERE t_test.id= 104;

二、修改字段默认值及为not null

alter table t_test alter name set not null default ‘’;

三、建表前默认先删表

DROP TABLE IF EXISTS t_test;
CREATE TABLE t_test (
id bigint not null,
name character varying(64),
CONSTRAINT pk_test_id PRIMAYRY KEY(id)
);