On 09/25/2010 07:03 AM, Tom Lane wrote:
> rey<reywang(at)optonline(dot)net> 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 even regex) delimiters would be
useful. Would it be reasonable for the copy process to differentiate
between single character delimiters which could be processed in
"high-speed" mode and multi-character or regex delimiters which would be
available as needed albeit at the expense of a performance hit?
Cheers,
Steve