On 10/12/2010 08:28 PM, Bruce Momjian wrote:
Steve Crawford wrote:
On 09/25/2010 07:03 AM, Tom Lane wrote:
rey writes:
Why limit this to a single character?
Performance. Believe it or not, breaking fields at the delimiter is
a significant factor in COPY speed.
Steve Crawford wrote:
> On 09/25/2010 07:03 AM, Tom Lane wrote:
> > rey writes:
> >
> >> Why limit this to a single character?
> >>
> > Performance. Believe it or not, breaking fields at the delimiter is
> > a significant factor in COPY speed.
> >
> > regards, tom la
On 09/25/2010 07:03 AM, Tom Lane wrote:
rey writes:
Why limit this to a single character?
Performance. Believe it or not, breaking fields at the delimiter is
a significant factor in COPY speed.
regards, tom lane
I agree that that multi-character (or eve
On Sat, Sep 25, 2010 at 3:12 PM, rey wrote:
> On 09/25/2010 10:03 AM, Tom Lane wrote:
>>
>> rey writes:
>>
>>>
>>> Why limit this to a single character?
>>>
>>
>> Performance. Believe it or not, breaking fields at the delimiter is
>> a significant factor in COPY speed.
>>
>>
On 09/25/2010 10:03 AM, Tom Lane wrote:
rey writes:
Why limit this to a single character?
Performance. Believe it or not, breaking fields at the delimiter is
a significant factor in COPY speed.
regards, tom lane
True, but just for 5% to 10% degradation
rey writes:
> Why limit this to a single character?
Performance. Believe it or not, breaking fields at the delimiter is
a significant factor in COPY speed.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your s
Hi,
/delimiter/
The single character that separates columns within each row (line)
of the file. The default is a tab character in text mode, a comma in
CSV mode.
Why limit this to a single character?
For easy of use, should it be lifted, so we can specify such as '|*|'?
Rey
