<p dir="ltr">Hey first copy has a couple of options that you should check.<br>
Secondly find one correct tin as text, and check that you can use st_geomfromtext on this tin, to be sure it is correct.<br>
Then<br>
create a test file with only the found tin with correct encoding and end of line. <br>
You should be ok .<br>
Chers<br>
Rémi-c</p>
<div class="gmail_quote">Le 4 juin 2015 21:53, "Hillier, Michael" <<a href="mailto:Michael.Hillier@nrcan-rncan.gc.ca">Michael.Hillier@nrcan-rncan.gc.ca</a>> a écrit :<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
<br>
<br>
I am trying to import a TIN surface into postgresql + postgis database from a file via an SQL COPY command.<br>
<br>
<br>
<br>
First off, here is my table:<br>
<br>
<br>
<br>
CREATE TABLE tintable(id int4 primary key, geom geometry(TIN,4326));<br>
<br>
<br>
<br>
Because the TIN data is too large (thousands of entries) I can not use the command<br>
<br>
INSERT INTO tintable (id,geom) VALUES (1,ST_GeomFromText('TIN(((1 0,0 1,1 1,1 0)))',4326));<br>
<br>
<br>
<br>
So I use the following:<br>
<br>
<br>
<br>
COPY tintable FROM 'C::\\users\\...' DELIMITERS '|'<br>
<br>
<br>
<br>
I have tried the following formats in the file I am trying to copy from:<br>
<br>
<br>
<br>
1|(0 0,0 1,1 1,0 0) -> ERROR: parse error - invalid geometry HINT: "(0" <-- parse error at position 2 within geometry<br>
<br>
<br>
<br>
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"<br>
<br>
<br>
<br>
1|((0 0,0 1,1 1,0 0)) -> ERROR: parse error - invalid geometry HINT: "((" <-- parse error at position 2 within geometry<br>
<br>
<br>
<br>
What is the correct file format so I can import TIN data using the command "COPY tintable FROM 'C::\\users\\...' DELIMITERS '|' "?<br>
<br>
<br>
<br>
Thank you<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote></div>