| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Bruce Momjian - CVS <momjian(at)postgresql(dot)org> |
| Cc: | pgsql-committers(at)postgresql(dot)org |
| Subject: | Re: pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ... |
| Date: | 2003-04-20 01:35:19 |
| Message-ID: | 1050802519.378.11.camel@tokyo |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
On Sat, 2003-04-19 at 15:55, Bruce Momjian - CVS wrote:
> Add pipe parameter to COPY function to allow proper line termination.
>
<para>
- Note that the end of each row is marked by a Unix-style newline
- (<quote><literal>\n</></>). Presently, <command>COPY FROM</command> will not behave as
- desired if given a file containing DOS- or Mac-style newlines.
- This is expected to change in future releases.
+ <command>COPY TO</command> will terminate each row with a Unix-style
+ newline (<quote><literal>\n</></>), or carriage return/newline
+ ("\r\n") on MS Windows. <command>COPY FROM</command> can handle lines
+ ending with newlines, carriage returns, or carriage return/newlines.
</para>
</refsect2>
You might want to clarify that it's the OS of the server (I assume) that
determines the line endings used by COPY TO.
Cheers,
Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-04-20 01:52:20 | Re: pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ... |
| Previous Message | Bruce Momjian - CVS | 2003-04-19 20:36:03 | pgsql-server/src/backend/commands copy.c |