| From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
|---|---|
| To: | Andrea Riciputi <andrea(dot)riciputi(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Extending COPY TO |
| Date: | 2014-09-23 06:53:26 |
| Message-ID: | 542118E6.1050504@vmware.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2014-09-23 06:56:19 | Re: Extending COPY TO |
| Previous Message | Andrea Riciputi | 2014-09-23 06:49:16 | Extending COPY TO |