hengjun6968的博客

项目中有遇到，做个简单记录用pg的if else语法实现DO$do$BEGINIF (SELECT COUNT(*) AS ct1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '表名' AND COLUMN_NAME = '字段名' ) = 0 --判断字段数量是不是0THEN alter table 表名 add c...