DO
$$
DECLARE
selectrow record;
BEGIN
FOR selectrow IN
SELECT 'ALTER TABLE ' || T.mytable || ' ADD COLUMN column_name varchar(32) NULL' AS script
FROM (
SELECT table_name AS mytable
FROM information_schema.columns
WHERE table_schema = 'public'
AND column_name = 'column_name'
) t
LOOP
EXECUTE selectrow.script;
END LOOP;
END;
$$;
SQL循环表新增字段
于 2022-05-20 16:53:08 首次发布
关键词由CSDN通过智能技术生成