What is the PostgreSQL equivalent to the TSQL “go” statement?
I have a query to insert a record into a table
--something like this
Insert into employee values(1,'Mike');
GO n;
I want this query to be executed n number of times.
Add a comment
|
3 Answers
This is possible without reverting to PL/pgSQL:
Insert into employee (id, name)
select 1,'Mike'
from generate_series(1,3);
Or if you want different IDs for each row:
Insert into employee (id, name)
select id,'Mike'
from generate_series(1,3) as t(id);
1 Comment
Fabricio
+1 it is also faster by about 30% here than the accepted answer inserting a million rows in a local table with random data
try using loop:
do
$$
declare
i record;
begin
for i in 1..3 loop
Insert into employee values(1,'Mike');
end loop;
end;
$$
;
Comments
https://xzilla.net//blog/2020/Nov/Do-This-10-Times-And-Stop-dot-dot-dot-In-Postgres.html
select $$Insert into emp values(1,'Mike') $$ from generate_series(1,10) \gexec
only applicable to psql https://www.postgresql.org/docs/current/app-psql.html
