On Sat, Nov 9, 2024, at 15:28, David G. Johnston wrote: > 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.
Clever idea, could work, but using NUL bytes in text files feels a bit unorthodox, and I can imagine surprising results in other systems having to deal with such files. I have no idea how useful such file format would be, but some googling suggest it's a trick that's used out there, so I won't exclude the idea entirely, just feels like a type of hack where it's difficult to foresee the consequences of allowing it. /Joel
