Re: Load data from a csv file without using COPY

Seriously, stop spamming the list and stop cursing and acting like a petulant child. Go to the site and unsubscribe or use a mail client that understands the standard list headers.

On June 19, 2018 6:06:59 PM EDT, Asif Ali <asif2k(at)hotmail(dot)com> wrote:
>how the fuck i unsubscribe to this mailing list , i get more than 100
>emails a day
>
>Bye
>
>________________________________
>From: Alban Hertroys <haramrae(at)gmail(dot)com>
>Sent: Wednesday, June 20, 2018 2:10 AM
>To: Ravi Krishna
>Cc: PG mailing List
>Subject: Re: Load data from a csv file without using COPY
>
>
>> On 19 Jun 2018, at 22:16, Ravi Krishna <srkrishna(at)yahoo(dot)com> 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.
>>
>> thanks
>
>I think an easy approach would be to COPY the CSV files into a separate
>database using psql's \copy command and then pg_dump that as separate
>insert statements with pg_dump —inserts.
>
>Alban Hertroys
>--
>If you can't see the forest for the trees,
>cut the trees and you'll find there is no forest.

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.