Re: pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ... - Mailing list 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