agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: ERROR: extra data after last expected column
Date: Mon, 7 Mar 2022 19:42:43 -0600
Message-ID: <1ed6d66d-0caa-36bb-21f5-df39adaa26e4@gmail.com> (raw)
In-Reply-To: <095fbaeb-9c9e-1c8f-42bd-d1e75eb81eb5@gmail.com>
References: <775429fc5428ca2640f72f1d29f6e8ec90955e6c.camel@gmail.com>
<CAKyoTgZ6gc-5_SocE55vbD50Mmhd4iP-A3j0mu-RHq+aTu94Lg@mail.gmail.com>
<a9c205a0-501c-ac7b-2b5c-7c25742ecef6@gmail.com>
<CACCHZrSQ_RvChnzR1nSzGBNpoPevhZvWiZg9bv0JdGHBEamP+A@mail.gmail.com>
<a7ead06c-0b69-acce-d55a-a959e79a6762@gmail.com>
<CACCHZrQpRDy1MCs_g7YfVJFWsTfoQNKP6d9JNJcYxL3X91hgeQ@mail.gmail.com>
<095fbaeb-9c9e-1c8f-42bd-d1e75eb81eb5@gmail.com>
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.
view thread (12+ messages) latest in thread
Message-ID: <1ed6d66d-0caa-36bb-21f5-df39adaa26e4@gmail.com>
Permalink: ../1ed6d66d-0caa-36bb-21f5-df39adaa26e4@gmail.com/
Also on: postgresql.org/message-id/1ed6d66d-0caa-36bb-21f5-df39adaa26e4@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: ERROR: extra data after last expected column
In-Reply-To: <1ed6d66d-0caa-36bb-21f5-df39adaa26e4@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox