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

The definition of the neptune.act table. The pgAdmin docs can walk you
through how to go about finding that if you cannot intuit how to navigate
the object browser it provides.

You need to count how many columns are on that table and compare them to
how many are in the csv file. You should find there are fewer in the table
which means you need to fix the table. If you find the counts to be the
same then it might be something different.

Dave

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

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