I tried to load a raster GeoTIFF image to a PostGIS database using "raster2pgsql" following the OpenGeo Suite Manual. The command I used is:
C:\>raster2pgsql -s 4283 -I -C -M "C:\Program Files\GeoServer 2.2.5\data_dir\data\gcur\interp_clipped.tif" -F public.myraster | psql -d MyPostGISDB -h localhost -p 5432 -U postgres
The table was successfully created and found in "pgAdmin III" but not accessible through QGis. When I tried to load PostGIS layers in QGIS, it only showed "raster_columns" not the "myraster" table. In the PostGIS Manager window in QGIS, this table is marked as plain table and with "No Geometry".
Can anyone give me some hints about it?
Thanks in advance!