[postgis-users] Loading geometrys from csv

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,\x01060001000103000100ba0a8717... I'm getting an error: ERROR

Re: [postgis-users] Restore a raster dump from PostGIS 2.1.0 to PostGIS 2.3.0

Hi Regina, Thanks a lot for your help and for the bug report. The temporary fix worked also for me. Regards, Cedric ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] Self-intersecting polygon gives ST_IsSimple=true

Hi, I do not understand this: select ST_IsValid( ST_GeomFromText( 'POLYGON (( 320 620, 460 620, 460 500, 320 620, 320 500, 180 500, 180 620, 320 620 ))' )); Result: "f". select ST_IsValidReason( ST_GeomFromText( 'POLYGON (( 320 620, 460 620, 460 500, 320 620, 320 500, 180 500, 180 620