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

Screenshot of what?

I will take now but please point me out.

On Sat, May 19, 2018 at 4:24 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> 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
>>
>
>

--
Milorad Krstevski

Mobile: +389 71 381 168
E-mail: miloradkrstevski(at)gmail(dot)com