When you create your table , don't define "the_geom" as a geometry, but rather as text or varchar.
Once loaded, then try
ALTER TABLE your_table ALTER COLUMN the_geom TYPE geometry USING the_geom::geometry;
> Message: 1
> Date: Fri, 5 May 2017 20:17:33 -0400
> From: John K <[hidden email]>
> To: [hidden email] > Subject: [postgis-users] Loading geometrys from csv
> <CAHSicSspAapz=[hidden email]>
> Content-Type: text/plain; charset=UTF-8
> I have a .csv file with a geometry, and I'm trying to load into a table.
> copy public.test FROM '/home/john/test.csv' with (FORMAT csv, DELIMITER E',' )
> The csv file has 4 columns and looks like:
> I'm getting an error:
> ERROR: parse error - invalid geometry
> HINT: "\x" <-- parse error at position 2 within geometry
> CONTEXT: COPY test, line 2, column geom:
> Is there anything obvious I'm doing wrong?
> Thanks in advance,