<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Dear PGIS users,<br>
<br>
I'm working with the postgis 2.0 : <br>
<ol>
<li>PostgreSQL 9.1.4, compiled by Visual C++ build 1500, 64-bit"</li>
<li>"POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel.
4.8.0, 6 March 2012" GDAL="GDAL 1.9.1, released 2012/05/15"
LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER"</li>
</ol>
<p>I'm trying to load a raster.tif (DEM) into my database with the
following command.<br>
</p>
<p>raster2pgsql -f elev -F -t 100x100 QC_SRTM.tif QC_SRTM | psql -U
postgres -d DEM -h localhost -p 5432 <br>
</p>
<p>And I catched this error;<br>
</p>
<p>INSERT 0 1<br>
INSERT 0 1<br>
INSERT 0 1<br>
INSERT 0 1<br>
INSERT 0 1<br>
INSERT 0 1<br>
INSERT 0 1<br>
INSERT 0 1<br>
psql:elev1.sql:5690: ERREUR: chaîne entre guillemets non terminée
sur ou près de « '010000010000000....<br>
</p>
<p>..... indicating that the string is not quoted near the last
line.<br>
</p>
<p>So I ran the raster2pgsql.exe with this command <br>
</p>
<p>D:\Data\Geodata\Altimetrie\SRTM\DEM90m\PreTraitement>raster2pgsql
-f elev -F -t 100x100 QC_SRTM.tif QC_SRTM > InsertSRTM.sql<br>
Processing 1/1: QC_SRTM.sdat<br>
</p>
and looked at the content of the sql file. The last line of the file
is cut and the command "END;" is not there. <br>
<br>
If I correct the file by ending the line and adding the "End;"
command the file is load.<br>
<br>
I was wondering what parameter would be responsible for that error
in raster2pgsql? <br>
<br>
I have many raster to load so this temporary solution is not a TRUE
solution. Anyone had an idea?<br>
<br>
Thanks.<br>
<br>
Jean-Daniel
</body>
</html>