一、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)
);