Alon Goldshuv wrote: > Bruce, > > Point taken. > > > Now, you can argue that > > a different escape should be possible, or that some other escape syntax > > could be used, but the existing mechanism is clearly 100% reliable when > > used properly and not broken. > > I think that having an option for another escape syntax (such as using > ESCAPE AS clause in delimited format (non-csv) COPY) with a default of '\\' > is a good compromise that will allow users to escape their data (like COPY > currently is), or by specifying another escape character allow all of their > backslashes to be treated as data. > > I'll start a new discussion about it on a new thread soon.
Yep, great. Right now we only support single-byte escapes (and delimiters), so there should be a discussion if multiple byte values are useful too. Also, there was discussion of what the default should be. I don't think there is any agreement to change the existing defaults. You might argue for a new mode that sets certain defaults to be easier to load, but I am afraid of a new format that isn't 100% reliable, because it assumes that some sequence of bytes will never appear in the data. Anyway, these are ideas you can consider when making a proposal. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match