| From: | "Clinton James" <cjames(at)callone(dot)net> |
|---|---|
| To: | "Postgres" <pgsql-general(at)postgresql(dot)org> |
| Subject: | RE: pqReadData() -- backend closed on COPY |
| Date: | 2001-07-02 19:23:32 |
| Message-ID: | LDEHLKIELLEDPDLPHDILAEDMCJAA.cjames@callone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-07-02 19:26:54 | Re: query optimizer questions |
| Previous Message | jtp | 2001-07-02 18:32:37 | on indexing. |