修改表名
ALTER TABLE name
RENAME TO new_name
修改字段默认值
alter table gzfy.tb_cis_patient_info
alter column pg_serial_number set default '00000000'
增加非空约束
alter table gzfy.tb_cis_patient_info
alter column pg_serial_number set not null
删除字段
alter table gzfy.tb_cis_patient_info
drop column pg_serial_number
去字段约束
约束名
alter table gzfy.tb_cis_patient_info drop CONSTRAINT tb_cis_patient_pkey