On 3/7/22 17:57, Rob Sargent wrote:
On 3/7/22 16:48, scott macri wrote:
[snip]
It pukes after the 9th column every time no matter what I change. COPY option_details(a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y) FROM '/home/dump/my_csv.csv' WITH (FORMAT CSV, DELIMITER '|', ENCODING 'UTF8');You've verified the encoding is UTF8?Row one data in file is below: item a | item b | item c | item d | item e | item f | item g | item h | item i | item j | item k | item l | item m | item n | item o | item p | item q | item r | item s | item t | item u | item v | item w | item x | item y --- Line two would normally start here but no reason to show since it's failing above. --- I get the following error: ERROR: extra data after last expected column CONTEXT: COPY option_details, line 1: "item a|item b|item c|item d|item e|item f|item g|item h|item i|..."
Might there be pipe characters in one of the columns? -- Angular momentum makes the world go 'round.
