Postgres Pro
Downloads
Home   >   mailing lists

pqReadData() -- backend closed on COPY - Mailing list pgsql-general

From Clinton James
Subject pqReadData() -- backend closed on COPY
Date
Msg-id LDEHLKIELLEDPDLPHDILIEDMCJAA.cjames@callone.net
Whole thread Raw
List pgsql-general
Tree view 
It looks like the tabs were changed in the file I sent.  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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: query optimizer questions
Next
From: Bruce Momjian
Date:
Subject: O'Reilly Open Source Convention