From: | Milorad Krstevski <miloradkrstevski(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15206: Can not import CSV into PostgreSQL |
Date: | 2018-05-19 14:14:27 |
Message-ID: | CACH_0ioQ9Du1sG85kNsb-jrATd8MkvuWtAqQAK2YBHU5OHdOHg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
Attachment | Content-Type | Size |
---|---|---|
backup_db | application/octet-stream | 2.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Milorad Krstevski | 2018-05-19 14:18:58 | Re: BUG #15206: Can not import CSV into PostgreSQL |
Previous Message | Milorad Krstevski | 2018-05-19 14:06:40 | Re: BUG #15206: Can not import CSV into PostgreSQL |