I'm not sure if my loading of raster images is correct. I use "raster2pgsql -s 4236 -I -C -M *.tif -F -t 100x100 public.demelevation | psql -d gisdb" from the manual. What I get is a table that has only 3 columns (rid, rast, filename) and 1 row only (I thought -t would create many rows). Also, 12 constraints. Finally, 1 row in the "raster_columns" view, which contains all the details of the loaded raster.
The difference with a loaded shapefile is that this table has 55.000 rows that contains all the vector data details. So I have a major problem when I connect to the database through QGIS. There I can load and display normally a shapefile from the database (it appeas with "MULTIPOLYGON" type), but all the tables which contains rasters appear with "no geometry" type and can't be displayed in QGIS. Can anyone tell me where is my fault, in the QGIS or in the first loading of the raster images in the database? Thanks.
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users