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
Last activity: Dec 17, 2022, 04:42 PM