Re: multiline CSV fields - Mailing list pgsql-hackers

From Tom Lane
Subject Re: multiline CSV fields
Date
Msg-id 12778.1100215009@sss.pgh.pa.us
Whole thread Raw
In response to Re: multiline CSV fields  (Patrick B Kelly <pbk@patrickbkelly.org>)
Responses Re: multiline CSV fields  (Patrick B Kelly <pbk@patrickbkelly.org>)
List pgsql-hackers
Patrick B Kelly <pbk@patrickbkelly.org> writes:
> What about just coding a FSM into 
> backend/commands/copy.c:CopyReadLine() that does not process any flavor 
> of NL characters when it is inside of a data field?

CopyReadLine has no business tracking that.  One reason why not is that
it is dealing with data not yet converted out of the client's encoding,
which makes matching to user-specified quote/escape characters
difficult.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: multiline CSV fields
Next
From: Andrew McMillan
Date:
Subject: Re: A modest proposal: get rid of GUC's USERLIMIT