Re: psql copy command - 1 char limitation on delimiter

On 09/25/2010 07:03 AM, Tom Lane wrote:
> rey<reywang@optonline.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