Hi guys,
I meet a problem when try to import data from a
Tab-delimited-text file to a table by command 'copy
from'. A sample procedure is explained as follow,
first, I
generate a file called /home/temp/test.txt,
let's suppose it has only two lines, ( the four figures are delimited by
tab)
123 456
789
999
Second, I type the following command under PSQL,
create table ttt ( c1 bigint, c2 bigint);
Finally, I
try to import the data from test.txt into table ttt by,
copy ttt from '/home/temp/test.txt';
But I was
told,
ERROR: copy: line 1, Bad int8 external
representation "'123'"
(My PostgreSQL is v7.1)
I would appreciate any help or advice.
thanks in advance,
Dong,
Meng
[EMAIL PROTECTED]
