You should upload the file first then run a scheduler task that reads it
and store into the database in background.
On Sunday, 5 October 2014 17:49:16 UTC-5, kenny c wrote:
>
> I've been trying to import big csv file into the database by running the
> private script, but the system kills it for
Kenny c,
Keep using the COPY, it's the correct way for large datasets. Add the
column list to the COPY command without the id column and be sure that the
table has the id column is defined as SERIAL type.
You can also try pgloader: http://pgloader.tapoueh.org/
2014-10-07 4:27 GMT+02:00 Massimo D
2 matches
Mail list logo