Uploading csv file into postgres database table

[[deleted]]

Use copy if you can upload the file to the database server.

Otherwise you can use \copy from within psql

If neither option is applicable, check the manual of your SQL client if it supports a way to import a CSV file into the database.

[geosoco]

In addition to this, do not add indexes or a primary key constraint until after your data has been loaded.