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..
-
What is the actual problem you are trying to solve?user330315– user3303152016-12-14 06:46:38 +00:00Commented Dec 14, 2016 at 6:46
Add a comment
|
3 Answers
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;
$$;
1 Comment
Mina
God bless the fruit of your mother's womb
Use generate_series:
INSERT INTO tableName (id) SELECT * FROM generate_series(1, 1000);
4 Comments
krithikaGopalakrishnan
is there a reason to avoid it? @Evan Carroll
Sameer
@EvanCarroll In case you want to generate some test data, or want to performance benchmark, you can always use this.
Evan Carroll
Yes, it's good for test data. Reasons to avoid it -- if it's a real ID column, it should be an identity column. If it's numbers on output you should use
ROW_NUMBER() OVER (), etc.
MarianP
this one's faster than the loop
INSERT INTO sub_category (category_id, sub_category_id, price)
SELECT 10001, gs, 5 FROM generate_series(1, 1000) AS gs;
