DO
$$
DECLARE
selectrow record;
BEGIN
FOR selectrow IN
SELECT 'ALTER TABLE ' || t.mytable || ' ADD COLUMN 字段名 类型 NULL' AS script
FROM (
SELECT table_name AS mytable
FROM information_schema.tables
WHERE table_schema = 'public' --schema name,子查询内容根据实际情况自定义
) t
LOOP
EXECUTE selectrow.script;
END LOOP;
END;
$$;
PostgreSQL:循环在数据库的多个表中新增一列
最新推荐文章于 2023-05-25 10:28:26 发布