Hello, 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: 1,113,31200,\x010600000001000000010300000001000000ba0a00008717... 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: "\x01060000000100000001030000000100000042050000ac1c5a643b4d55c0333674b33f3c40401daa29c93a4d55c0333674..." Is there anything obvious I'm doing wrong? Thanks in advance, John _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
