Dominique Devienne wrote: > These values are 'normal'. I'm not use to CSV, but I suppose > such newlines > must be encoded, perhaps as \n, since AFAIK CSV needs to be 1 line per row, > no?
No, but such fields must be enclosed by double quotes, as documented in RFC 4180 https://datatracker.ietf.org/doc/html/rfc4180 Consider this output: psql> COPY (values (1, E'ab\ncd'), (2,'efgh')) TO STDOUT CSV; 1,"ab cd" 2,efgh That's 2 records on 3 lines. If you feed this to a parser and it chokes on it, it means that it's not a valid CSV parser. Best regards, -- Daniel Vérité https://postgresql.verite.pro/ Twitter: @DanielVerite
