From: jam paydavousi <jampaydavousi@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations
Date: Wed, 25 May 2022 22:10:53 +0000 (UTC)
Message-ID: <486515877.1710597.1653516653132@mail.yahoo.com> (raw)
In-Reply-To: <2019391.1653515838@sss.pgh.pa.us>
References: <17498-7b8108cfd105f161@postgresql.org>
<1999259.1653509169@sss.pgh.pa.us>
<569491626.1695111.1653513632963@mail.yahoo.com>
<2019391.1653515838@sss.pgh.pa.us>
Hi Tom,
It is odd that there was no description in the Failed error code:1 in pgAdmin, suggesting mismatch between how the column needs to be defined so SQl can import it. The psql error description on command line on Mac terminal was detailed, to the point, and helpful in troubleshooting it.
Thanks for your timely reply and help in troubleshooting. My PostgreSQL tables are loading all CSV files now, my python code in Flask is reading and converting data from SQL using SQLAlchemy with no errors, and my front end is showing the data. All si good now.
Best Regards to you.
Jam
On Wednesday, May 25, 2022, 02:57:21 PM PDT, Tom Lane <tgl@sss.pgh.pa.us> wrote:
jam paydavousi <jampaydavousi@yahoo.com> writes:
> Thank you for following up Tom. I did what you instructed- i.e., filing distinctly from pgAdmin link you provided.
> However, I have the same issue when I attempt to import the csv file via the command line interface on mac terminal. It copies 0 rows
> postgres-# \copy alove from '/Users/jam/alovel.csv' delimiter ',' csv header;
> COPY 0
Hm. Sure looks like Postgres thinks the file is empty.
That "CSV HEADER" option would silently eat the first line, so I'm
wondering if the data looks like it's a single line to COPY,
ie maybe there is something funny about the newlines in your file.
You could check this theory easily by leaving off "CSV HEADER"
and seeing if the results change.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: jampaydavousi@yahoo.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17498: Receive Failed: (error code 1) when importing any csv file from pgAdmin with no explanations
In-Reply-To: <486515877.1710597.1653516653132@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox