Hello,
I am trying to import a TIN surface into postgresql + postgis database from a file via an SQL COPY command. First off, here is my table: CREATE TABLE tintable(id int4 primary key, geom geometry(TIN,4326)); Because the TIN data is too large (thousands of entries) I can not use the command INSERT INTO tintable (id,geom) VALUES (1,ST_GeomFromText('TIN(((1 0,0 1,1 1,1 0)))',4326)); So I use the following: COPY tintable FROM 'C::\\users\\...' DELIMITERS '|' I have tried the following formats in the file I am trying to copy from: 1|(0 0,0 1,1 1,0 0) -> ERROR: parse error - invalid geometry HINT: "(0" <-- parse error at position 2 within geometry 1|0 0,0 1,1 1,0 0 -> ERROR: Invalid hex string, length (15) has to be a multiple of two! CONTEXT: COPY tintable, line 1, column geom: "0 0,0 1,1 1,0 0" 1|((0 0,0 1,1 1,0 0)) -> ERROR: parse error - invalid geometry HINT: "((" <-- parse error at position 2 within geometry What is the correct file format so I can import TIN data using the command "COPY tintable FROM 'C::\\users\\...' DELIMITERS '|' "? Thank you _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users