|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.66 2005/06/02 01:21:21 momjian Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/copy.sgml,v 1.67 2005/09/05 14:44:05 adunstan Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -511,6 +511,19 @@ COPY <replaceable class="parameter">tablename</replaceable> [ ( <replaceable cla |
511 | 511 | comparisons for specific columns. |
512 | 512 | </para> |
513 | 513 |
|
| 514 | + <note> |
| 515 | +<para> |
| 516 | + In <literal>CSV</> mode, all characters are significant. A quoted value |
| 517 | + surrounded by white space, or any characters other than |
| 518 | + <literal>DELIMITER</>, will include those characters. This can cause |
| 519 | + errors if you import data from a system that pads <literal>CSV</> |
| 520 | + lines with white space out to some fixed width. If such a situation |
| 521 | + arises you might need to preprocess the <literal>CSV</> file to remove |
| 522 | + the trailing white space, before importing the data into |
| 523 | + <productname>PostgreSQL</>. |
| 524 | +</para> |
| 525 | + </note> |
| 526 | + |
514 | 527 | <note> |
515 | 528 | <para> |
516 | 529 | CSV mode will both recognize and produce CSV files with quoted |
|