Re: Unworkable column delimiter characters for COPY - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Unworkable column delimiter characters for COPY
Date
Msg-id 4773D9CA.1030708@dunslane.net
Whole thread Raw
In response to Unworkable column delimiter characters for COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Unworkable column delimiter characters for COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:
> Currently, copy.c rejects newline, carriage return, and backslash as
> settings for the column delimiter character (in non-CSV mode).  These
> all seem necessary to avoid confusion.  However, I just noticed that the
> letters r, n, t, etc would also not work: on output, data characters
> matching such a delimiter would get escaped as \r, \n, etc, which on
> input would be read as C-style control characters.
>
> I think at minimum we need to forbid b, f, n, r, t, v, which are the
> control character representations currently recognized by COPY.
> But I'm tempted to make it reject all 26 lower-case ASCII letters,
> as a form of future-proofing.  Thoughts?
>
>   

Assuming this is only for non-CSV mode, it seems OK.

cheers

andrew



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Binary data type with other output method
Next
From: Andrew Sullivan
Date:
Subject: Re: Spoofing as the postmaster