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