Sample Header Ad - 728x90

unterminated CSV quoted field when to import csv data file into postgresql

1 vote
2 answers
6620 views
Create a table : CREATE TABLE num ( id serial NOT NULL , adsh VARCHAR(20) NOT NULL, tag VARCHAR(256) NOT NULL, version VARCHAR(20) NOT NULL, coreg VARCHAR(256), ddate date NOT NULL, qtrs DECIMAL(8) NOT NULL, uom VARCHAR(20), value DECIMAL(28,4), footnote VARCHAR(512) ); I want to import the sample.txt data into num table:
adsh	tag	version	coreg	ddate	qtrs	uom	value	footnote
0001213900-20-033598	DueToAsiyaCommunicationsSapiDeC.v.Current	0001213900-20-033598		20191231	0	USD		
0001213900-20-033598	DueToDinarZuzLLC	0001213900-20-033598		20200630	0	USD	178000.0000	Due to the April 6, 2020 180 days Loan Agreement with the Company to borrow up to $250 at an annual interest rate of nine percent (9.0%) ("the second "Dinar Zuz Note").
0001213900-20-033598	DueToNextCalaCurrent	0001213900-20-033598		20181231	0	USD	-14000.0000	
0001213900-20-033598	DueToNextCalaCurrent	0001213900-20-033598		20191231	0	USD
The command to import the data in sample.txt into the table: COPY num(adsh,tag,version,coreg,ddate,qtrs,uom,value,footnote) FROM 'sample.txt' DELIMITER E'\t' CSV HEADER; It encounter an error: ERROR: unterminated CSV quoted field CONTEXT: COPY num, line 6: "0001213900-20-033598 DueToDinarZuzLLC 0001213900-20-033598 20200630 0 USD 178000.0000 Due to the Ap..." Please fix it without editing the primitive data.
Asked by showkey (386 rep)
Jan 27, 2022, 11:30 AM
Last activity: Oct 21, 2024, 04:02 PM