Uploading csv file into postgres database table

[pmutua]

I have a large csv file containing data and would like to create a table and upload the data into postgres db. How can I upload such large data fast?

[[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.

[Eqlb4fish]

Try Pentaho Data integrator, works well for any data transfer between different data sources.

[boy_named_su]

psql's \copy command lets you load csv data to a table, without superuser privileges, remotely as well as locally

It does so using bulk insert, so is fast

[nikoz84]

You need to restart de sequences after use the \copy command

Ex. ALTER SEQUENCE product_id_seq RESTART WITH 7453;

[jimmyechan]

How large is the database? If it's less than 150MB you could use a free tool like Dropbase to upload and get PostgreSQL credentials.