tsql - How to execute a query multiple times in PostgreSQL -


what postgresql equivalent tsql “go” statement?

i have query insert record table

--something this

insert employee values(1,'mike');

go n;

i want query executed n number of times.

try using loop:

do $$ declare    record; begin   in 1..3 loop     insert employee values(1,'mike');   end loop; end; $$ ; 

Comments