[postgis-users] Import Raster with 3 bands to PostgreSQL

[José Pedro Santos]

Hi Pierre, 

In QGIS and yes, QGIS interpret the images with 3 bands because I can see the image but when I import to PostgreSQL and try to see the result I can't.

What is the difference between a image and a raster?? both have pixel values but image have from 0 to 255 so are equal and raster2pgsql work fine with that. I guess that only import the first band values and not the others so there’s the problem I think...that’s why I ask. 

Thanks anyway.

Regards
José Santos  

> From: Pierre.Racine at sbf.ulaval.ca
> To: postgis-users at lists.osgeo.org
> Date: Mon, 10 Dec 2012 11:37:16 -0500
> CC: mauricio.dev at gmail.com
> Subject: Re: [postgis-users] Import Raster with 3 bands to PostgreSQL
> 
> Which software? The software has to interpret himself the three bands as RGB. I don't think QGIS does that...
> 
> There is nothing in PostGIS stating that a three bands raster is a TIFF or JPEG file. PostGIS store rasters, not images.
> 
> Pierre
> 
> > -----Original Message-----
> > From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> > bounces at lists.osgeo.org] On Behalf Of José Pedro Santos
> > Sent: Monday, December 10, 2012 11:26 AM
> > To: postgis-users at lists.osgeo.org
> > Subject: [postgis-users] Import Raster with 3 bands to PostgreSQL
> > 
> > Dear all,
> > 
> > I import with sucess a 3 band image to PostgreSQL 9.1 with the raster2pgsql in
> > Ubuntu 12.04LTS. But when I try to visualize in another software I can't see the
> > image and it looks like the values from the other bands glue only in the first
> > band. Do you know if there's any problem with the import option of rasters with
> > 3 bands to PostgreSQL?
> > My Postgis version is 2.0.1.
> > 
> > Best Regards and thanks,
> > Jose Santos
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121211/39650b66/attachment.html>