Peter Eisentraut <pete...@gmx.net> writes: > Alternative consideration: We could allow this in CSV format if we made > users quote the first value if it starts with a BOM. This might be a > reasonable way to get MS compatibility.
I don't think we can get away with a retroactive restriction on the contents of data files. If we're going to do this at all, I still think an explicit BOM option for COPY, to either eat (and require) a BOM on input or emit a BOM on output, would be the sanest way. None of the "automatic" approaches seem safe to me. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers