Sample Header Ad - 728x90

How to insert 10000 new rows?

13 votes
3 answers
33973 views
Presumably there is a straight forward and easy solution. I'm wanting to create 10000 new rows - that are numbered sequentially with no data per row (except sequentially numbered id). I have used:
INSERT INTO bins (id)
VALUES (1)
to create a single row with id '1' How do I create 10000 rows with corresponding id number? Version: PostgreSQL 9.5.5
Asked by Andrew (131 rep)
Oct 29, 2017, 09:48 AM
Last activity: Dec 17, 2022, 04:42 PM