Re: BUG #15206: Can not import CSV into PostgreSQL

A screenshot would be better for me, dealing with a dump file is too
high-maintenance for this kind of question.

On Sat, May 19, 2018 at 7:18 AM, Milorad Krstevski <
miloradkrstevski(at)gmail(dot)com> wrote:

> Is this OK?
>
> Please let me know. Thank you.
>
> On Sat, May 19, 2018 at 4:14 PM, Milorad Krstevski <
> miloradkrstevski(at)gmail(dot)com> wrote:
>
>> Here is the backup of the whole db.
>>
>> It is empty. The pass is: miki (in case you need it).
>>
>> On Sat, May 19, 2018 at 3:57 PM, Milorad Krstevski <
>> miloradkrstevski(at)gmail(dot)com> wrote:
>>
>>> Respected,
>>>
>>> Thank you very much for the prompt reply.
>>>
>>> I am trying to import the following files in new created empty table in
>>> postgre db and schema (both are neptun, and the table is act):
>>> 1. s1.csv - is created manually by me (encoding UTF8 and delimiter ;) -
>>> attachment 1
>>> 2. act2017short2.csv - is taken from system (I just put 10 lines here) -
>>> attachment 2
>>>
>>> The error that is shown in the import is below. I go import as CSV -
>>> encoding UTF8 with header and delimiter ; - nothing else in the import
>>> wizard is changed.
>>> 1. Attachment 3: Error 1
>>> 2. Attachment 4: Error 2
>>>
>>> Can you please point me out where is my mistake? Thank you.
>>>
>>> Respectfully,
>>> Milorad K.
>>>
>>>
>>> On Sat, May 19, 2018 at 2:55 PM, David G. Johnston <
>>> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>>>
>>>> On Sat, May 19, 2018 at 4:19 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com
>>>> > wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> 2018-05-19 11:09 GMT+02:00 PG Bug reporting form <
>>>>> noreply(at)postgresql(dot)org>:
>>>>>
>>>>>> The following bug has been logged on the website:
>>>>>>
>>>>>> Bug reference: 15206
>>>>>> Logged by: Milorad Krstevski
>>>>>> Email address: miloradkrstevski(at)gmail(dot)com
>>>>>> PostgreSQL version: 10.4
>>>>>> Operating system: Ubuntu 18.04 LTS x64
>>>>>> Description:
>>>>>>
>>>>>> Respected,
>>>>>>
>>>>>> No matter what I try, I always get the error: ERROR: extra data after
>>>>>> last
>>>>>> expected column, and can not import CSV into table in PostgreSQL.
>>>>>>
>>>>>> I am using pgAdmin 4.30, Python 3.6.5, Flask 0.12.2.
>>>>>>
>>>>>> Can you please point out solution to my problem please?
>>>>>>
>>>>>
>>>>> It is not PostgreSQL bug, so pg_general mailing list will be better.
>>>>>
>>>>> PostgreSQL is very strict about CSV format - it looks so some line of
>>>>> CSV doc has more columns than target table.
>>>>>
>>>>
>>>> ​IOW, we cannot help unless you provide both the CSV file and the table
>>>> definition.
>>>>
>>>> David J.
>>>> ​
>>>>
>>>
>>>
>>>
>>> --
>>> Milorad Krstevski
>>>
>>> Mobile: +389 71 381 168
>>> E-mail: miloradkrstevski(at)gmail(dot)com
>>>
>>
>>
>>
>> --
>> Milorad Krstevski
>>
>> Mobile: +389 71 381 168
>> E-mail: miloradkrstevski(at)gmail(dot)com
>>
>
>
>
> --
> Milorad Krstevski
>
> Mobile: +389 71 381 168
> E-mail: miloradkrstevski(at)gmail(dot)com
>