<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Hi Pierre, <br><br>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.<br><br>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. <br><br>Thanks anyway.<br><br>Regards<br>José Santos <br><br><div><div id="SkyDrivePlaceholder"></div>> From: Pierre.Racine@sbf.ulaval.ca<br>> To: postgis-users@lists.osgeo.org<br>> Date: Mon, 10 Dec 2012 11:37:16 -0500<br>> CC: mauricio.dev@gmail.com<br>> Subject: Re: [postgis-users] Import Raster with 3 bands to PostgreSQL<br>> <br>> Which software? The software has to interpret himself the three bands as RGB. I don't think QGIS does that...<br>> <br>> There is nothing in PostGIS stating that a three bands raster is a TIFF or JPEG file. PostGIS store rasters, not images.<br>> <br>> Pierre<br>> <br>> > -----Original Message-----<br>> > From: postgis-users-bounces@lists.osgeo.org [mailto:postgis-users-<br>> > bounces@lists.osgeo.org] On Behalf Of José Pedro Santos<br>> > Sent: Monday, December 10, 2012 11:26 AM<br>> > To: postgis-users@lists.osgeo.org<br>> > Subject: [postgis-users] Import Raster with 3 bands to PostgreSQL<br>> > <br>> > Dear all,<br>> > <br>> > I import with sucess a 3 band image to PostgreSQL 9.1 with the raster2pgsql in<br>> > Ubuntu 12.04LTS. But when I try to visualize in another software I can't see the<br>> > image and it looks like the values from the other bands glue only in the first<br>> > band. Do you know if there's any problem with the import option of rasters with<br>> > 3 bands to PostgreSQL?<br>> > My Postgis version is 2.0.1.<br>> > <br>> > Best Regards and thanks,<br>> > Jose Santos<br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@lists.osgeo.org<br>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br></div> </div></body>
</html>