On Friday, May 8, 2020, PG Bug reporting form <
noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 16424
Logged by: Vivek Kamath
Email address: vivek4422@gmail.com
PostgreSQL version: 10.6
Operating system: Linux Unix
Description:
Hi,
I am copying a csv file where the fields are quoted with " and separated by
,.
I am using below syntax to copy data using below syntax
psql -c "COPY table_name from filename WITH (FORMAT csv)".
Replace that command with something that will handle the poorly structured csv data you are receiving. COPY is very linear and unforgiving when it comes to accepting input so you need something that will feed copy that well-formed data it expects).
David J.