[postgis-users] Loading geometrys from csv

John K jtkrulick at gmail.com
Fri May 5 17:17:33 PDT 2017


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


More information about the postgis-users mailing list