From: Tom Lane <tgl@sss.pgh.pa.us>
To: jam paydavousi <jampaydavousi@yahoo.com>
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
In-reply-to: <569491626.1695111.1653513632963@mail.yahoo.com>
References: <17498-7b8108cfd105f161@postgresql.org>
 <1999259.1653509169@sss.pgh.pa.us>
 <569491626.1695111.1653513632963@mail.yahoo.com>
Comments: In-reply-to jam paydavousi <jampaydavousi@yahoo.com>
	message dated "Wed, 25 May 2022 21:20:32 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2019390.1653515838.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 25 May 2022 17:57:18 -0400
Message-ID: <2019391.1653515838@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2019391.1653515838%40sss.pgh.pa.us>
Precedence: bulk

jam paydavousi <jampaydavousi@yahoo.com> writes:
>  Thank you for following up Tom. =C2=A0I 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 he=
ader;

> 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