<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19394"></HEAD>
<BODY bgColor=#ffffff text=#000000>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013>Hello,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013>If you want to see your rasters in qgis you should
:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013>1. add raster constraint using -C option if you
didn't</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013>2. you may try WKT rasters plugin for
qgis</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013>3. you can try to use
st_dumpaspolygons</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013>For the last two options, this page will provide more
informations : <A
href="http://trac.osgeo.org/postgis/wiki/WKTRaster">http://trac.osgeo.org/postgis/wiki/WKTRaster</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=325515814-04022013>Hugues.</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV align=left><FONT size=2 face=Arial></FONT> </DIV><BR>
<DIV dir=ltr lang=fr class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Ivan
Frigerio<BR><B>Sent:</B> Monday, February 04, 2013 3:57 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] postgis
raster<BR></FONT><BR></DIV>
<DIV></DIV>Hi guys,<BR><BR>I try to upload a rasterfile (geotif) into a postgis
database. I used <B>raster2pgsql</B> and the resulted was a table with
three columns like that: <B>rid, rast, filename</B>. My goal is to work with
Qgis desktop, so I tried to load raster but I observed that my new postgis
raster <B>has not a geometry column</B>, so I can not share my postigs raster
into Qgis.<BR><BR>Someone know how can I resolve this
problem?<BR><BR>Thanks!<BR><BR>Ivan<BR></BODY></HTML>