postgresql 修改列添加列等操作

-- 添加列

ALTER table planting_identification_tag add identification_tag_unique_id varchar(64);

ALTER table trace_env_factor add sample_value varchar(1024);
ALTER table trace_env_factor add image varchar(1024);


-- 添加备注
COMMENT ON COLUMN "public"."planting_identification_tag"."identification_tag_unique_id" IS ‘标签库uniqueId‘;


-- 修改列名

ALTER TABLE trace_env_factor  RENAME  trace_env_index_unique_id  to trace_env_factor_unique_id ;
ALTER TABLE trace_env_factor  RENAME  env_index_name  to name ;
ALTER TABLE trace_env_factor  RENAME  env_index_code  to unit ;

ALTER TABLE trace_env_factor  RENAME  env_index_description  to description ;


-- 修改字段类型
alter table trace_env_factor alter column unit type varchar(64);


-- 修改表名
alter table trace_env_index rename to trace_env_factor;


--删除列  -存在该字段才删除
alter table bas_cm_tenant_verification drop column if exists verify_type;