Postgresql: Create an insert query that inserts multiple records in a range

Question

I'm starting from a CSV file with a lot of zipcode in the form:

FROM;TO;CITY
1000;1200;TESTCITY

and I want to insert it in a postgres table with the columns:

So, for each row in the CSV, I must create "TO - FROM" records in the table.

Is there a way to do this with a simple query, like

insert into zipcodes (zipcode, cityname) 
select RANGE(1000;1200), cityname;

D-Shih · Accepted Answer · 2018-07-05 08:10:46Z

2

You can try to use generate_series

insert into zipcodes (zipcode, cityname) 
SELECT  num,'TESTCITY' as cityname
FROM    generate_series(1000,1200) num

answered Jul 5, 2018 at 8:10

D-Shih

46.5k6 gold badges37 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1