|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.89 2009/09/17 21:49:15 momjian Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.90 2009/09/18 20:01:13 tgl Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -183,8 +183,8 @@ COPY { <replaceable class="parameter">tablename</replaceable> [ ( <replaceable c |
183 | 183 | <listitem> |
184 | 184 | <para> |
185 | 185 | The string that represents a null value. The default is |
186 | | - <literal>\N</literal> (backslash-N) in text mode, anda empty |
187 | | -value with no quotes in <literal>CSV</> mode. You might prefer an |
| 186 | + <literal>\N</literal> (backslash-N) in text mode, andan unquoted empty |
| 187 | +string in <literal>CSV</> mode. You might prefer an |
188 | 188 | empty string even in text mode for cases where you don't want to |
189 | 189 | distinguish nulls from empty strings. |
190 | 190 | </para> |
@@ -249,8 +249,7 @@ COPY { <replaceable class="parameter">tablename</replaceable> [ ( <replaceable c |
249 | 249 | In <literal>CSV</> <command>COPY TO</> mode, forces quoting to be |
250 | 250 | used for all non-<literal>NULL</> values in each specified column. |
251 | 251 | <literal>NULL</> output is never quoted. If <literal>*</> is specified, |
252 | | - non-<literal>NULL</> values for all columns of the table will be |
253 | | - quoted. |
| 252 | + non-<literal>NULL</> values will be quoted in all columns. |
254 | 253 | </para> |
255 | 254 | </listitem> |
256 | 255 | </varlistentry> |
@@ -550,11 +549,11 @@ COPY <replaceable class="parameter">count</replaceable> |
550 | 549 | <para> |
551 | 550 | The <literal>CSV</> format has no standard way to distinguish a |
552 | 551 | <literal>NULL</> value from an empty string. |
553 | | - <productname>PostgreSQL</>'s <command>COPY</> handles this by |
554 | | -quoting.A <literal>NULL</> is output as the <literal>NULL</> |
555 | | -parameterand is not quoted, while a non-NULL value matching the |
556 | | -the<literal>NULL</> parameter string is quoted.Therefore, using the default |
557 | | - settings, a <literal>NULL</> is written as an unquoted empty |
| 552 | + <productname>PostgreSQL</>'s <command>COPY</> handles this by quoting. |
| 553 | + A <literal>NULL</> is output as the <literal>NULL</> parameter string |
| 554 | + and is not quoted, while a non-<literal>NULL</> value matching the |
| 555 | + <literal>NULL</> parameter string is quoted. For example, with the |
| 556 | +defaultsettings, a <literal>NULL</> is written as an unquoted empty |
558 | 557 | string, while an empty string data value is written with double quotes |
559 | 558 | (<literal>""</>). Reading values follows similar rules. You can |
560 | 559 | use <literal>FORCE NOT NULL</> to prevent <literal>NULL</> input |
|