Postgresql Insert Loop
Commands
do $$
declare
counter integer := 0;
begin
while counter < 100000 loop
insert into public.person (first_name, last_name) values ('Jack', 'Twin');
counter := counter + 1;
end loop;
end$$;
ing. M.A.C.M. (Martijn) van den BoomComputer Infrastructure Architectingenieur, docent en mentor
Commands
do $$
declare
counter integer := 0;
begin
while counter < 100000 loop
insert into public.person (first_name, last_name) values ('Jack', 'Twin');
counter := counter + 1;
end loop;
end$$;