Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15206: Can not import CSV into PostgreSQL - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: BUG #15206: Can not import CSV into PostgreSQL
Date
Msg-id CAFj8pRAUxnoGmCPzjjGxh4QT1LWMv=Miybc=k5r4E22ahb2Cfw@mail.gmail.com
Whole thread Raw
In response to BUG #15206: Can not import CSV into PostgreSQL  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15206: Can not import CSV into PostgreSQL  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view
Hi

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

Regards

Pavel

Thank you.
Milorad K.


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15206: Can not import CSV into PostgreSQL
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #15206: Can not import CSV into PostgreSQL