I tried to load raster file (jpg) into post gis using the syntax provided here "C:\Program Files (x86)\PostgreSQL\9.1\bin>raster2pgsql -I -C -e -Y -F -s 102003 -t 300x300 ras_test.tif ras_test1 | psql .exe -U postgres -d raster_analysis -h localhost -p 5434"
I could see a raster table created in the database. It has three columns (rid,rast, filename), where you do not see any thing under "rast raster" column unless you click on a particular cell.
Here is my actual problem. How to view the raster layer from ArcGIS using sql query layer. When I tried adding this layer and validate it, it says "rast raster" column has invalid data type. How can I view the raster layer in ArcGIS?
I could however, able to see the raster layer in QGIS using a plugin. However, my work needs access from arcGIS 10.
It is mentioned in this link, http://trac.osgeo.org/postgis/wiki/WKTRaster, that You can not display rasters directly but a vectorization of them (in ArcGIS 10). How to do this?