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

From Ravi Krishna
Subject Re: Load data from a csv file without using COPY
Date
Msg-id BA19C38F-C515-4F58-92E5-2C3473A9E604@yahoo.com
Whole thread Raw
In response to Re: Load data from a csv file without using COPY  (Steve Atkins <steve@blighty.com>)
Responses Re: Load data from a csv file without using COPY  (Steve Atkins <steve@blighty.com>)
Re: Load data from a csv file without using COPY  (Rob Sargent <robjsargent@gmail.com>)
RE: Load data from a csv file without using COPY  (Kevin Brannen <KBrannen@efji.com>)
List pgsql-general
>
> If performance is relevant then your app should probably be using COPY protocol, not line by line inserts. It's
> supported by most postgresql access libraries. If your app does that then using "\copy" from psql would be
> an appropriate benchmark.

Actually the reluctance to not use COPY is to make the benchmark same across two different RDBMS in
two diff env.

pgsql-general by date:

Previous
From: Alban Hertroys
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