存储过程,批量生成大量数据
CREATE
OR REPLACE FUNCTION batch_insert_proc ( num INT ) RETURNS void AS $$ BEGIN
while
num > 0
loop
INSERT INTO students (id, name, age, grade)
VALUES (1, '张三', 18, '高三');
num = num - 1;
END loop;
EXCEPTION
WHEN OTHERS THEN
raise EXCEPTION '(%)',
SQLERRM;
END;
$$ LANGUAGE plpgsql;
-- 插入10*100条数据 数据库存储过程
SELECT
batch_insert_proc ( 10 * 100 );