Postgres Pro
Downloads
Home   >   mailing lists

Re: Load data from a csv file without using COPY - Mailing list pgsql-general

From Nicolas Paris
Subject Re: Load data from a csv file without using COPY
Date
Msg-id CA+ssMORgpZW+iUNaNGsaxSHbHie+dwrB80Bd0y7jB3WJeSz7cQ@mail.gmail.com
Whole thread Raw
In response to Load data from a csv file without using COPY  (Ravi Krishna <srkrishna@yahoo.com>)
Responses Re: Load data from a csv file without using COPY  ("Ravi Krishna" <srkrishna@yahoo.com>)
List pgsql-general
Tree view
hi

AFAIK you can use copy from a jdbc command since copy allows to stream data (from stdin version)
However while faster than INSERT INTO,  this might lock the target table during the process

2018-06-19 22:16 GMT+02:00 Ravi Krishna <srkrishna@yahoo.com>:
In order to test a real life scenario (and use it for benchmarking) I want to load large number of data from csv files. 
The requirement is that the load should happen like an application writing to the database ( that is, no COPY command).
Is there a tool which can do the job.  Basically parse the csv file and insert it to the database row by row.

thanks





pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: Load data from a csv file without using COPY
Next
From: Hans Schou
Date:
Subject: Re: Load data from a csv file without using COPY