On 06/19/2018 01:16 PM, Ravi Krishna wrote:
> 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.
http://csvkit.readthedocs.io/en/1.0.3/scripts/csvsql.html
>
> thanks
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com