Copy 導入數(shù)據(jù)是報'RROR: copy: line 1, Bad float4 input format '1.60

zhhui2000

表結構：

1. CREATE TABLE "bstk" (
   
2.         "xh" integer,
   
3.         "jym" character(4),
   
4.         "answer" character varying(300),
   
5.         "answerp" character varying(300),
   
6.         "score" double precision
   
7. );

復制代碼

psql -Usa -d bsdb <bsdb.test
'RROR:  copy: line 1, Bad float8 input format '1.60
lost synchronization with server, resetting connection

bsdb.test:

1. COPY bstk FROM stdin;
   
2. 1       0610    91,4403,,12,34730.18,   91過渡,4403,,英鎊,34730.18,     1.60
   
3. 2       2305    691412238902981,599041718342036,00,0,45,459346293,12,1,77587206.77,76580096.46,91,1876,,        691412238902981,599041718342036,超期還款,全額還款,45,459346293,英鎊,現(xiàn)匯,77587206.77,76580096.46,91過渡,1876,,  7.5
   
4. 999     1103    91,2762,,0,,,57460.33,2006,77,060,,001,,1,      91過渡,2762,,現(xiàn)鈔,,,57460.33,2006,77,060,,憑印鑒,,通兌, 3.9
   
5. \.

復制代碼

renxiao2003

你的數(shù)據(jù)好像不符合表的結構吧。

zhhui2000

數(shù)據(jù)是TAB 分隔的。

zhhui2000

問題在dos/unix文件格式上，unix文件使用了回車換行作為行結束符。