Re: Load data from a csv file without using COPY

It's people like you who make spam filters worse for the rest of us to the point they need to be checked daily for false positives. I'm sure you could have found it in less time than it took to spam the list with obscenities.

On June 19, 2018 6:13:49 PM EDT, Asif Ali <asif2k(at)hotmail(dot)com> wrote:
>please just tell me the site i will do it right away and i have marked
>it junked so many times , i will keep spamming it until my email
>address is removed from the list
>
>Bye
>
>________________________________
>From: James Keener <jim(at)jimkeener(dot)com>
>Sent: Wednesday, June 20, 2018 3:11 AM
>To: pgsql-general(at)lists(dot)postgresql(dot)org; Asif Ali; Alban Hertroys; Ravi
>Krishna
>Cc: PG mailing List
>Subject: 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.

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