sql - pgAdmin4 .csv import is failing

Question

I have been trying to import data from a .csv file into a table (first time postgres /pgAdmin user) without success.

So I tried a simpler structure with only two columns as follows:

CREATE TABLE user
(
  firstName text,
  lastName text,
)

And this .csv:

firstName,lastName
Thomas,Johnson

My import configuration in pgAdmin4:

And the error I keep getting:

I tried changing text to varying char with enough char lenght without success..

Thank you for your help!

I've seen reports like this several times. It seems to be a bug in pgAdmin4, and only showing up on Macs. Does the data show up in the database? If you look in the database server's log file, do you see any errors report there? — jjanes, Jun 09 '20 at 12:27
@jjanes you were right, it was a permission issue on Mac, the .csv file needed to be moved to the /tmp folder to be accessible by pgAdmin4 — Wizzardzz, Jun 09 '20 at 15:47

score 0 · Answer 1 · answered Jun 09 '20 at 14:45

0

Your csv file has to be like below

"firstName", "lastName"
"Thomas", "Johnson"

answered Jun 09 '20 at 14:45

Nagesh Dhope

score 0 · Answer 2 · answered Jun 09 '20 at 15:47

0

It was a permission issue on Mac.

The .csv file needed to be moved to the \tmp folder in order to be accessible in pgAdmin4!

answered Jun 09 '20 at 15:47

Wizzardzz

2 Answers2