RE: pqReadData() -- backend closed on COPY
| От | Clinton James |
|---|---|
| Тема | RE: pqReadData() -- backend closed on COPY |
| Дата | |
| Msg-id | LDEHLKIELLEDPDLPHDILAEDMCJAA.cjames@callone.net обсуждение исходный текст |
| Ответ на | pqReadData() -- backend closed on COPY ("Clinton James" <cjames@callone.net>) |
| Список | pgsql-general |
It looks like the tabs were changed as I sent the file. Either think of each | as a tab, or use the DELIMITERS '|' on the COPY command. Clinton -----start import.head----- 0105|10102806|0001|20010328|12:25|0000841001|0001234567|SACRAMENTO|CA|0.6|00 0000000|0.0500 0105|10102806|0001|20010411|17:27|0000841001|0001234567|MT VIEW|CA|0.7|000000000|0.0500 0105|10102806|0001|20010402|13:41|0000841287|0001234567|MT VIEW|CA|0.7|000000000|0.0500 0105|10102806|0001|20010402|13:43|0000841287|0001234567|DENVER|CO|0.9|000000 000|0.0700 0105|10102806|0001|20010403|11:00|0000841287|0001234567|PLEASANTON|CA|1.0|00 0000000|0.0700 0105|10102806|0001|20010411|16:48|0000841287|0001234567|ROCKVL CTR|NY|1.1|000000000|0.0800 0105|10102806|0001|20010411|16:51|0000841287|0001234567|ATLANTA|GA|0.7|00000 0000|0.0500 0105|10102806|0001|20010411|16:53|0000841287|0001234567|KENOSHA|WI|0.4|00000 0000|0.0300 0105|10102806|0001|20010411|16:55|0000841287|0001234567|LEAGUECITY|TX|0.8|00 0000000|0.0600 0105|10102806|0001|20010411|16:57|0000841287|0001234567|GREEN BAY|WI|0.8|000000000|0.0600 -----end import.head-----
В списке pgsql-general по дате отправления: