Actually there are various ways to achieve this. Firstly you can use the PostGreSQL’s
copy command. Secondly you can choose to use Ruby to load data.
copy command in PG
Create your table:
CREATE TABLE zip_codes (ZIP char(5), LATITUDE double precision, LONGITUDE double precision, CITY varchar, STATE char(2), COUNTY varchar, ZIP_CLASS varchar);
Copy data from your CSV file to the table: Continue reading