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

From Adrian Klaver
Subject Re: Load data from a csv file without using COPY
Date
Msg-id 0bcfb5d0-f51f-0ca7-1ca9-b967cc110e81@aklaver.com
Whole thread Raw
In response to Load data from a csv file without using COPY  (Ravi Krishna <srkrishna@yahoo.com>)
List pgsql-general
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.klaver@aklaver.com


pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Load data from a csv file without using COPY
Next
From: "Ravi Krishna"
Date:
Subject: Re: Load data from a csv file without using COPY