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

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