On 09/23/2014 09:49 AM, Andrea Riciputi wrote:
My idea was to extend the COPY TO command to accept an EOL option as it already does with the DELIMITER option. To keep it simple we can limit the EOL choice to CR, LF or CRLF to avoid unusual output, and also keep the current behaviour when no EOL option is given. I was also wondering if an EOL option could be useful also for the text output format or not.
I don't think we want to go down that path. There are plenty of options in COPY already, and the more you add, the more complicated it gets. And we're never going to be able to satisfy everyone's needs.
I'd suggest doing: COPY table TO PROGRAM 'unix2dos > /tmp/file' - Heikki -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers