How to load 100k + Records into progres database from a CSV file?
You can use the COPY command for this.

See:
http://www.postgresql.org/docs/9.3/static/sql-copy.html
https://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgres-table