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)
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,
pgsql-bugs by date
|Next:||From: Wolfgang Winkler||Date: 2001-08-01 14:21:27|
|Subject: locale and german umlauts|
|Previous:||From: Stephan Szabo||Date: 2001-07-31 22:43:14|
|Subject: Re: ERROR: parser: parse error at or near "execute"|