Re: pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ...

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ...
Дата
Msg-id 1050802519.378.11.camel@tokyo
обсуждение исходный текст
Ответ на pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ...  (momjian@postgresql.org (Bruce Momjian - CVS))
Ответы Re: pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ...  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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


В списке pgsql-committers по дате отправления:

Предыдущее
От: momjian@postgresql.org (Bruce Momjian - CVS)
Дата:
Сообщение: pgsql-server/src/backend/commands copy.c
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pgsql-server/ oc/src/sgml/ref/copy.sgml rc/bac ...