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
