Re: psql copy command - 1 char limitation on delimiter

Steve Crawford wrote:
> 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?

I am not sure you are aware but Postgres never confuses delimiters from
data because it uses a backslash before literal data that matches
delimiters.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +