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@xxxxxxxxx>:
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