1.通用方法:
eg:
DO $$
BEGIN
BEGIN
ALTER TABLE dingtalk_corp_info ADD COLUMN admin_id TEXT;
EXCEPTION
WHEN duplicate_column THEN RAISE NOTICE 'column admin_id already exists in dingtalk_corp_info.';
END;
END;
$$;
2.pgsql 9.6+:
eg:
ALTER TABLE dingtalk_corp_info ADD COLUMN IF NOT EXISTS admin_id TEXT;
3.直接添加
eg:
ALTER TABLE dingtalk_corp_info
ADD COLUMN admin_id TEXT;