<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div id="yiv1315890287"><div><div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:12pt;"><div id="yiv1315890287yui_3_2_0_15_131892611913576">I have one "rid" column and one "rast" column but only with one row, 1 - 0. So i guess the upload wasn't correct, right? I tried the command you said but no error messages. I use OSGeo4W console and i have installed through this the GDAL 1.8.1-1. Sometimes i get a message saying: gdalinfo.exe - System Error "The program can't start because MSVCR90.dll is missing from your computer. Try reinstalling the program to fix this problem". I reinstalled osgeo4w but nothing changed. Maybe that's the problem? I should start installing dlls manually? Any other way to install gdal 1.8 without OSGeo4W in Windows 7 exists?<br><br><br><br><span
id="yiv1315890287yui_3_2_0_15_131892611913575"></span></div><div id="yiv1315890287yui_3_2_0_15_131892611913577"><span id="yiv1315890287yui_3_2_0_15_131892611913575"></span></div><div><br id="yiv1315890287yui_3_2_0_15_131892611913551"></div><div class="yiv1315890287yui_3_2_0_15_131892611913552" id="yiv1315890287yui_3_2_0_15_131892611913554" style="font-family:times new roman, new york, times, serif;font-size:12pt;"><div class="yiv1315890287yui_3_2_0_15_131892611913557" style="font-family:times new roman, new york, times, serif;font-size:12pt;"><font size="2" face="Arial"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Pierre Racine <Pierre.Racine@sbf.ulaval.ca><br><b><span style="font-weight:bold;">To:</span></b> Giannis Giakoumidakis
<ggiakoumidakis@yahoo.com>; PostGIS Users Discussion <postgis-users@postgis.refractions.net><br><b><span style="font-weight:bold;">Sent:</span></b> Monday, October 17, 2011 5:08 PM<br><b><span style="font-weight:bold;">Subject:</span></b> RE: [postgis-users] Questions about the right uploading of raster data<br></font><br>
> What i get in my database is a new table with the name of my image with no<br>> data inside (only "1" in rid serial) and a row at the raster_columns with all data<br>> of the uploaded image except the nodata_values. <br><br>You should have one "rid" column and one "rast" column. And since you loaded using the -k option you should have many rows in the "katrina" table.<br><br>If this is not what you get I would suggest to replace the <a rel="nofollow" target="_blank" href="http://raster2pgsql.py">raster2pgsql.py</a> -o option with a pipe like this:<br><br>raster2pgsql.py -r /path/to/katrina.tif -t katrina -l 1 -k 64x64 -s 4326 -I -M > Katrina.sql<br><br>to see more error message.<br><br>> I tried to import them with -n but it doesn't work with raster2pgsql.py. I connect to my database with QGIS<br>> 1.7.1 through WTKRaster plugin and what i get is no geometry and no data at all<br>> in the raster table (as expected) and the
raster_columns
appears as a polygon<br>> with the right coordinates but with no texture inside (only one color polygon).<br><br>Before trying to display in QGIS make sure the raster was loaded properly...<br><br>Pierre<br><br><br><br></div></div></div></div></div></div></body></html>