<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Disregard what I said. I see that the SQL statements I thought mistakenly were coming from DbManager are generated by GDAL (looking at the GDAL postgis raster code).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>So the change would need to be done in GDAL driver. I think having a PostGIS function GDAL can count on calling that would always return the materialized raster tile would simplify things though.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>So I'm thinking strongly of implementing that in PostGIS 2.4. I think all other calls that GDAL is doing to for example get meta data and overviews would be the same for out-db as it is for in-db.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Even,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Any input you have on the matter would be very welcomed. I guess this would need to wait for GDAL 2.2 or 2.3 and verify said helper function exists (or version of PostGIS) before it can be used.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Regina Obe [mailto:lr@pcorp.us] <br><b>Sent:</b> Tuesday, May 02, 2017 4:04 PM<br><b>To:</b> 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org><br><b>Cc:</b> 'PostGIS Development Discussion' <postgis-devel@lists.osgeo.org><br><b>Subject:</b> RE: [postgis-users] raster2pgsql: out_db=false with -R flag (And Showing out_db rasters in QGIS)<o:p></o:p></span></p></div></div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Just to add the bug regarding raster2pgsql will be fixed in upcoming 2.3.3<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>And the work-around is to use –Y with –s as detailed in the ticket.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><a href="https://trac.osgeo.org/postgis/ticket/3738">https://trac.osgeo.org/postgis/ticket/3738</a><o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regarding the QGIS issue with GDAL not supporting out-db. I've been thinking that the easier fix might be to make the change in QGIS DbManager instead of PostGIS.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>The ultimate problem is that PostGIS is feeding an out-db raster instead of the raster bytes. QGIS just makes queries to the PostGIS database and uses GDAL to consume the raw bytes.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>If QGIS dbmanager were to instead of doing SELECT rast … did something like SELECT ST_Materialize(rast) AS rast …. FROM somerast table …<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Where yet to be implemented PostGIS function ST_Materialize or whatever we decide to call it does nothing with in-db, but returns the raster bytes of out-db, then QGIS DbManager can treat out-db like any in-db raster.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I'm thinking this would be a faster fix than mucking with PostGIS GDAL driver and in the end might help simplify the PostGIS GDAL driver handling of out-db since it can use the same function.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>strk,<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I think you are familiar with the internal workings of QGIS Db Manager. You think this proposed option is feasible and less taxing or we'd still need to do something on the GDAL end to make this work?<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Tumasgiu Rossini<br><b>Sent:</b> Tuesday, May 02, 2017 8:26 AM<br><b>To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> Re: [postgis-users] raster2pgsql: out_db=false with -R flag (And Showing out_db rasters in QGIS)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p><div><div><div><p class=MsoNormal style='margin-left:1.0in'>I think that raster2pgsql is indeed a mature tool, but it is the out-db feature of postgis<o:p></o:p></p></div><p class=MsoNormal style='margin-left:1.0in'>which is maybe not widely used, and so the bugs takes more time to appear because<o:p></o:p></p></div><p class=MsoNormal style='margin-left:1.0in'>of the fewer users.<o:p></o:p></p><div><div><div><div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p><div><p class=MsoNormal style='margin-left:1.0in'>2017-05-02 12:18 GMT+02:00 <<a href="mailto:Michael.Haertel@t-systems.com" target="_blank">Michael.Haertel@t-systems.com</a>>:<o:p></o:p></p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Hello Tumasgiu Rossini,</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>thank you very much for your fast and comprehensive response. I was not aware of that bug yet but found so many references to raster2pgsql that I just assumed that it was a mature tool already. </span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>(And noted that I gave wrong parameter in the subject line of my mail, should have been R and not F).</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Good luck with your programming efforts. I guess it’s somewhat complex since you have to deal with the real pixel data. </span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regards,</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Michael</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=DE><o:p></o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><b><span style='font-size:10.0pt;font-family:"Tahoma",sans-serif'>Von:</span></b><span style='font-size:10.0pt;font-family:"Tahoma",sans-serif'> postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>Im Auftrag von </b>Tuma</span><span lang=DE style='font-size:10.0pt;font-family:"Tahoma",sans-serif'>sgiu Rossini<br><b>Gesendet:</b> Dienstag, 2. Mai 2017 12:08<br><b>An:</b> PostGIS Users Discussion<br><b>Betreff:</b> Re: [postgis-users] raster2pgsql: out_db=false with -F flag (And Showing out_db rasters in QGIS)</span><span lang=DE><o:p></o:p></span></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE> <o:p></o:p></span></p><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;margin-left:1.0in'><span lang=DE>Hi,<o:p></o:p></span></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE>To answer your first question : <o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE>the combination of the -s and -R options actually transforms out-db raster into in-db,<o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt;margin-left:1.0in'><span lang=DE>it is a recent known bug, see <a href="https://lists.osgeo.org/pipermail/postgis-users/2017-April/042003.html" target="_blank">https://lists.osgeo.org/pipermail/postgis-users/2017-April/042003.html</a> <br>for more information.<o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE>For the latter question,<o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE>Qgis uses gdal to fetch raster data from postgis and the out-db support is not implemented.<o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE>You can though maybe use workarounds, more info here :<br><a href="https://lists.osgeo.org/pipermail/postgis-users/2017-April/042077.html" target="_blank">https://lists.osgeo.org/pipermail/postgis-users/2017-April/042077.html</a><br><a href="https://lists.osgeo.org/pipermail/postgis-users/2017-April/042053.html" target="_blank">https://lists.osgeo.org/pipermail/postgis-users/2017-April/042053.html</a><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE> <o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE>Using out-db rasters and Qgis at my company, I am facing myself this problem and<o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE>I am trying to implement out-db support in gdal, though I am no gdal developer<o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE>and it is not a high priority feature.<o:p></o:p></span></p></div></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE> <o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE>2017-05-02 11:37 GMT+02:00 <<a href="mailto:Michael.Haertel@t-systems.com" target="_blank">Michael.Haertel@t-systems.com</a>>:<o:p></o:p></span></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Dear users,</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I hope that somebody can tell me if I found a bug or simply don’t use the command correctly.</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Given:</span><span lang=DE><o:p></o:p></span></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:10.0pt;font-family:Symbol'>·</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>A directory with four GeoTIFF files </span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:10.0pt;font-family:Symbol'>·</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>PostgreSQL 9.6.1, compiled by Visual C++ build 1800, 64-bit</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:10.0pt;font-family:Symbol'>·</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>POSTGIS="2.3.1 r15264" GEOS="3.6.0-CAPI-1.10.0 r4265" SFCGAL="1.3.0" PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.1.1, released 2016/07/07" LIBXML="2.7.8" LIBJSON="0.12" RASTER</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:10.0pt;font-family:Symbol'>·</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>OS is Windows 7</span><span lang=DE><o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I try to import the Tiff files as OUT_DB raster files using this command:</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Courier New"'>1.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Courier New"'>raster2pgsql.exe -s 25832 -I -R -n myFilename -C -M -F C:\_GEODATA_\*.tif raster2x2 > t:\DTK10.sql<br><br></span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Output:</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>a.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Processing 1/4: C:\_GEODATA_\24_dtk10_32356_5608_2_nw_col.tif</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>b.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Processing 2/4: C:\_GEODATA_\25_dtk10_32356_5610_2_nw_col.tif</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>c.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Processing 3/4: C:\_GEODATA_\34_dtk10_32358_5608_2_nw_col.tif</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>d.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Processing 4/4: C:\_GEODATA_\35_dtk10_32358_5610_2_nw_col.tif</span><span lang=DE><o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Courier New"'>2.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Courier New"'>psql.exe --host=localhost --port=5432 --username=xxx --dbname=xxx -f t:\DTK10.sql</span><span lang=DE><o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'><br>Output:</span><span lang=DE><o:p></o:p></span></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>a.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>BEGIN</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>b.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>CREATE TABLE</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>c.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>INSERT 0 1</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>d.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>INSERT 0 1</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>e.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>INSERT 0 1</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>f.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>INSERT 0 1</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>g.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>CREATE INDEX</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>h.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>ANALYZE</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>i.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding SRID constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>j.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding scale-X constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>k.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding scale-Y constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>l.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding blocksize-X constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>m.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding blocksize-Y constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>n.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding alignment constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>o.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding number of bands constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>p.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding pixel type constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>q.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding nodata value constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>r.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding out-of-database constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>s.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>psql:t:/DTK10.sql:9: HINWEIS: Adding maximum extent constraint</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>t.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>addrasterconstraints</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>u.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>----------------------</span><span lang=DE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>v.</span><span lang=DE style='font-size:7.0pt'> </span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>t</span><span lang=DE><o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Problem is that the view “raster_columns” always shows FALSE for out_db, even though I used the F flag:</span><span lang=DE><o:p></o:p></span></p></div><table class=MsoNormalTable border=0 cellpadding=0 width=544 style='width:408.0pt;margin-left:1.0in'><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"r_table_catalog"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"r_table_schema"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"r_table_name"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"r_raster_column"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"srid"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"scale_x"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"scale_y"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"blocksize_x"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"blocksize_y"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"same_alignment"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"regular_blocking"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"num_bands"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"pixel_types"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"nodata_values"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"out_db"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"extent"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"spatial_index"<o:p></o:p></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"gismobile"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"public"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"raster2x2 "<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"rast"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>25832<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0.5<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>-0.5<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>4000<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>4000<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>true<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>false<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>1<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>{8BUI}<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>{NULL}<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>{f}<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0103000020E864000001000000050000000000000080BA154100000000906455410000000080BA154100000000786855410000000000F9154100000000786855410000000000F9154100000000906455410000000080BA15410000000090645541<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>true<o:p></o:p></p></td></tr></table><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><table class=MsoNormalTable border=0 cellpadding=0 width=96 style='width:1.0in;margin-left:1.0in'><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"rid"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"rast"<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"filename"<o:p></o:p></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>1<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0100000100000000000000E03F000000000000E0BF0000000080BA1541000000008466554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C32345F64746B31305F33323335365F353630385F325F6E775F636F6C2E74696600<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"24_dtk10_32356_5608_2_nw_col.tif"<o:p></o:p></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>2<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0100000100000000000000E03F000000000000E0BF0000000080BA1541000000007868554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C32355F64746B31305F33323335365F353631305F325F6E775F636F6C2E74696600<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"25_dtk10_32356_5610_2_nw_col.tif"<o:p></o:p></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>3<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0100000100000000000000E03F000000000000E0BF00000000C0D91541000000008466554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C33345F64746B31305F33323335385F353630385F325F6E775F636F6C2E74696600<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"34_dtk10_32358_5608_2_nw_col.tif"<o:p></o:p></p></td></tr><tr><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>4<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>0100000100000000000000E03F000000000000E0BF00000000C0D91541000000007868554100000000000000000000000000000000E8640000A00FA00F840000433A5C5F47454F444154415F5C33355F64746B31305F33323335385F353631305F325F6E775F636F6C2E74696600<o:p></o:p></p></td><td style='padding:.75pt .75pt .75pt .75pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"35_dtk10_32358_5610_2_nw_col.tif"<o:p></o:p></p></td></tr></table><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>What I found out: As soon as I omit the s flag (to provide a SRS) the column shows TRUE.</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I guess that this is not the intended behaviour is it?</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>My QGIS 2.18 only shows black boxes for out_db rasters, the rasters themselves (pixel values) only appear for “in-DB” rasters. Did anybody succeed in showing out_db rasters in QGIS?</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Interestiung is also that gdalinfo is not showing any extents although it shows correct SRS and the “extent” column is populated (see above):</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Courier New"'>C:\_PortableApps_\pgsql\bin>"c:\QGIS\bin\gdalinfo.exe" PG:"dbname='xxx' host='localhost' port='5432' user='mhaerte2' password='xxx' table='raster2x2'"</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Driver: PostGISRaster/PostGIS Raster driver</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Files: none associated</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Size is 0, 0</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Coordinate System is:</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>PROJCS["ETRS89 / UTM zone 32N",</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> GEOGCS["ETRS89",</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> DATUM["European_Terrestrial_Reference_System_1989",</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> SPHEROID["GRS 1980",6378137,298.257222101,</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","7019"]],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> TOWGS84[0,0,0,0,0,0,0],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","6258"]],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PRIMEM["Greenwich",0,</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","8901"]],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> UNIT["degree",0.0174532925199433,</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","9122"]],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","4258"]],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PROJECTION["Transverse_Mercator"],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PARAMETER["latitude_of_origin",0],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PARAMETER["central_meridian",9],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PARAMETER["scale_factor",0.9996],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PARAMETER["false_easting",500000],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> PARAMETER["false_northing",0],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> UNIT["metre",1,</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","9001"]],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AXIS["Easting",EAST],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AXIS["Northing",NORTH],</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> AUTHORITY["EPSG","25832"]]</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Subdatasets:</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> --- snip! --</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Corner Coordinates:</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Upper Left ( 0.0, 0.0)</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Lower Left ( 0.0, 0.0)</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Upper Right ( 0.0, 0.0)</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Lower Right ( 0.0, 0.0)</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Center ( 0.0, 0.0)</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Does anyone have a clue? </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Thank you for your comments,</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Michael</span><span lang=DE><o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=DE><o:p></o:p></span></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></span></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;margin-left:1.0in'><span lang=DE> <o:p></o:p></span></p></div></div></div><p class=MsoNormal style='margin-left:1.0in'><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p></blockquote></div><p class=MsoNormal style='margin-left:1.0in'><o:p> </o:p></p></div></div></div></div></div></div></body></html>