# 添加boolean 类型字段默认值为FALSE不能为NULL
ALTER TABLE table_name
ADD COLUMN column_name boolean DEFAULT FALSE NOT NULL;
# 添加varchar类型字段默认值为1不能为NUL最大长度为5
ALTER TABLE table_name
ADD COLUMN column_name varchar(5) DEFAULT '1'::character varying NOT NULL;