How to insert data in postgresql using for loop?

Question

I would like to know how to insert data in postgresql using for loop?

I want to insert 1 to 1000 in row of id..

Answer 1

Please try below code to insert values in tables using for loop.

do $$ begin for r in 1..1000 loop insert into schema_name.table_name(id) values(r); end loop; end; $$;