On Saturday, November 9, 2024, Joel Jacobson <j...@compiler.org> wrote:
> On Fri, Nov 8, 2024, at 22:47, David G. Johnston wrote: > > On Fri, Nov 8, 2024 at 2:20 PM Joel Jacobson <j...@compiler.org> wrote: > >> > >> 1. Text files containing \. in the middle of the file > >> % cat /tmp/test.txt > >> foo > >> \. > >> bar > >> > >> Or another option to turn off the special meaning of \.? > > > > This does seem like an orthogonal option worth considering. > > I agree; if we want to integrate this into 'text', it's an option worth > considering. PostgreSQL cannot store the NUL byte. Would that be an option for the record separator. Default to new line but accept NUL if one needs to input/output lists containing newlines. Or whatever character the user believes is not part of their data - tab probably being a popular option. David J.
