postgresql——存储过程使用while循环

DO $$
declare
	var_count integer;
begin
var_count := 0;
	while var_count < 1000 loop
		execute('INSERT INTO "boy"("name", "age") VALUES (''a'', 11)');
		execute('INSERT INTO "boy"("name", "age") VALUES (''a'', 12)');
		execute('INSERT INTO "boy"("name", "age") VALUES (''a'', 13)');
		execute('INSERT INTO "boy"("name", "age") VALUES (''b'', 11)');
		execute('INSERT INTO "boy"("name", "age") VALUES (''b'', 12)');
		execute('INSERT INTO "boy"("name", "age") VALUES (''b'', 11)');
		execute('INSERT INTO "boy"("name", "age") VALUES (''c'', 12)');
		var_count := var_count+1;
	end loop;
end $$;