On 06/19/2018 03:18 PM, Asif Ali wrote:
just tell me the site , i dont have time to waste on shitty things , i
will program a spammer to send email to this list
So why subscribe in the first place?
Bye
------------------------------------------------------------------------
*From:* James Keener <jim@xxxxxxxxxxxxx>
*Sent:* Wednesday, June 20, 2018 3:16 AM
*To:* Asif Ali; pgsql-general@xxxxxxxxxxxxxxxxxxxx; Alban Hertroys; Ravi
Krishna
*Subject:* 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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx>
*Sent:* Wednesday, June 20, 2018 3:11 AM
*To:* pgsql-general@xxxxxxxxxxxxxxxxxxxx; 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@xxxxxxxxxxx> wrote:
how the fuck i unsubscribe to this mailing list , i get more
than 100 emails a day
Bye
------------------------------------------------------------------------
*From:* Alban Hertroys <haramrae@xxxxxxxxx>
*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@xxxxxxxxx> 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.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
