Re: BUG #15206: Can not import CSV into PostgreSQL
| От | Milorad Krstevski |
|---|---|
| Тема | Re: BUG #15206: Can not import CSV into PostgreSQL |
| Дата | |
| Msg-id | CACH_0iq3nZrgLEdZcTkDj9OuvyejmRiWfKtVG1QbviMUNKwETQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #15206: Can not import CSV into PostgreSQL ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: BUG #15206: Can not import CSV into PostgreSQL
Re: BUG #15206: Can not import CSV into PostgreSQL |
| Список | pgsql-bugs |
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.g.johnston@gmail.com> wrote:
Hi2018-05-19 11:09 GMT+02:00 PG Bug reporting form <noreply@postgresql.org>:The following bug has been logged on the website:
Bug reference: 15206
Logged by: Milorad Krstevski
Email address: miloradkrstevski@gmail.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.
--
Вложения
В списке pgsql-bugs по дате отправления: