Delay or Wait-For Statement

Question

I have a 500,000 line SQL script:

update users set region_id = 9814746 where id = 101 and region_id is null;
update users set region_id = 9814731 where id = 102 and region_id is null;
update users set region_id = 3470676 where id = 103 and region_id is null;

I want to INSERT a delay of 10 seconds every 50 lines. Does pgsql have a waitfor statement like t-sql.

Thanks.

user_6466035 · Answer

As pilcrow says that is the easiest way. If you do not want to see the results back, just turn off display before running pg_sleep like this -->

\pset tuples_only on
select pg_sleep(10) ;
\pset tuples_only off

Delay or Wait-For Statement

4 Answers