<div dir="ltr"><div><div>I think that raster2pgsql is indeed a mature tool, but it is the out-db feature of postgis<br></div>which is maybe not widely used, and so the bugs takes more time to appear because<br></div>of the fewer users.<br><div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2017-05-02 12:18 GMT+02:00 <span dir="ltr"><<a href="mailto:Michael.Haertel@t-systems.com" target="_blank">Michael.Haertel@t-systems.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="DE">
<div class="m_8499325093940295196WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">Hello Tumasgiu Rossini,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">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. <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">(And noted that I gave wrong parameter in the subject line of my mail, should have been R and not F).<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">Good luck with your programming efforts. I guess it’s somewhat complex since you have to deal with the real pixel data.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">Regards,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">Michael<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US"><u></u> <u></u></span></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US">Von:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US"> postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<wbr>lists.osgeo.org</a>]
<b>Im Auftrag von </b>Tuma</span><span 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)<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi,<u></u><u></u></p>
</div>
<p class="MsoNormal">To answer your first question : <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">the combination of the -s and -R options actually transforms out-db raster into in-db,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">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/<wbr>pipermail/postgis-users/2017-<wbr>April/042003.html</a> <br>
for more information.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">For the latter question,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Qgis uses gdal to fetch raster data from postgis and the out-db support is not implemented.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">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/<wbr>pipermail/postgis-users/2017-<wbr>April/042077.html</a><br>
<a href="https://lists.osgeo.org/pipermail/postgis-users/2017-April/042053.html" target="_blank">https://lists.osgeo.org/<wbr>pipermail/postgis-users/2017-<wbr>April/042053.html</a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Using out-db rasters and Qgis at my company, I am facing myself this problem and<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I am trying to implement out-db support in gdal, though I am no gdal developer<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">and it is not a high priority feature.<u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">2017-05-02 11:37 GMT+02:00 <<a href="mailto:Michael.Haertel@t-systems.com" target="_blank">Michael.Haertel@t-systems.com</a><wbr>>:<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Dear users,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span 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.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Given:<u></u><u></u></span></p>
</div>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:10.0pt;font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">A directory with four GeoTIFF files
<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:10.0pt;font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">PostgreSQL 9.6.1, compiled by Visual C++ build 1800, 64-bit<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:10.0pt;font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span 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<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:10.0pt;font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">OS is Windows 7<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span 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:<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Courier New""><span>1.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span 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 style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Output:</span><span style="font-size:11.0pt;font-family:"Courier New""><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>a.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Processing 1/4: C:\_GEODATA_\24_dtk10_32356_<wbr>5608_2_nw_col.tif<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>b.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Processing 2/4: C:\_GEODATA_\25_dtk10_32356_<wbr>5610_2_nw_col.tif<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>c.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Processing 3/4: C:\_GEODATA_\34_dtk10_32358_<wbr>5608_2_nw_col.tif<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>d.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Processing 4/4: C:\_GEODATA_\35_dtk10_32358_<wbr>5610_2_nw_col.tif<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Courier New""><span>2.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Courier New"">psql.exe --host=localhost --port=5432 --username=xxx --dbname=xxx -f t:\DTK10.sql<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><br>
Output:<u></u><u></u></span></p>
</div>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>a.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">BEGIN<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>b.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">CREATE TABLE<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>c.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">INSERT 0 1<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>d.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">INSERT 0 1<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>e.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">INSERT 0 1<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>f.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">INSERT 0 1<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>g.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">CREATE INDEX<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>h.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">ANALYZE<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>i.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding SRID constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>j.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding scale-X constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>k.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding scale-Y constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>l.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding blocksize-X constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>m.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding blocksize-Y constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>n.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding alignment constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>o.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding number of bands constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>p.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding pixel type constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>q.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding nodata value constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>r.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding out-of-database constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>s.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">psql:t:/DTK10.sql:9: HINWEIS: Adding maximum extent constraint<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>t.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">addrasterconstraints<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>u.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">----------------------<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:0cm">
<u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><span>v.<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">t<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span 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:<u></u><u></u></span></p>
</div>
<table class="m_8499325093940295196MsoNormalTable" style="width:1080.0pt" cellpadding="0" border="0" width="1440">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"r_table_catalog"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"r_table_schema"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"r_table_name"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"r_raster_column"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"srid"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"scale_x"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"scale_y"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"blocksize_x"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"blocksize_y"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"same_alignment"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"regular_blocking"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"num_bands"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"pixel_types"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"nodata_values"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"out_db"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"extent"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"spatial_index"<u></u><u></u></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"gismobile"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"public"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"raster2x2 "<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"rast"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">25832<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">0.5<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">-0.5<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">4000<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">4000<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">true<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">false<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">1<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">{8BUI}<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">{NULL}<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">{f}<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">0103000020E8640000010000000500<wbr>00000000000080BA15410000000090<wbr>6455410000000080BA154100000000<wbr>786855410000000000F91541000000<wbr>00786855410000000000F915410000<wbr>0000906455410000000080BA154100<wbr>00000090645541<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">true<u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<table class="m_8499325093940295196MsoNormalTable" style="width:481.1pt" cellpadding="0" border="0" width="641">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"rid"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"rast"<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"filename"<u></u><u></u></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">1<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">0100000100000000000000E03F0000<wbr>00000000E0BF0000000080BA154100<wbr>000000846655410000000000000000<wbr>0000000000000000E8640000A00FA0<wbr>0F840000433A5C5F47454F44415441<wbr>5F5C32345F64746B31305F33323335<wbr>365F353630385F325F6E775F636F6C<wbr>2E74696600<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"24_dtk10_32356_5608_2_nw_col.<wbr>tif"<u></u><u></u></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">2<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">0100000100000000000000E03F0000<wbr>00000000E0BF0000000080BA154100<wbr>000000786855410000000000000000<wbr>0000000000000000E8640000A00FA0<wbr>0F840000433A5C5F47454F44415441<wbr>5F5C32355F64746B31305F33323335<wbr>365F353631305F325F6E775F636F6C<wbr>2E74696600<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"25_dtk10_32356_5610_2_nw_col.<wbr>tif"<u></u><u></u></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">3<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">0100000100000000000000E03F0000<wbr>00000000E0BF00000000C0D9154100<wbr>000000846655410000000000000000<wbr>0000000000000000E8640000A00FA0<wbr>0F840000433A5C5F47454F44415441<wbr>5F5C33345F64746B31305F33323335<wbr>385F353630385F325F6E775F636F6C<wbr>2E74696600<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"34_dtk10_32358_5608_2_nw_col.<wbr>tif"<u></u><u></u></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">4<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">0100000100000000000000E03F0000<wbr>00000000E0BF00000000C0D9154100<wbr>000000786855410000000000000000<wbr>0000000000000000E8640000A00FA0<wbr>0F840000433A5C5F47454F44415441<wbr>5F5C33355F64746B31305F33323335<wbr>385F353631305F325F6E775F636F6C<wbr>2E74696600<u></u><u></u></p>
</td>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal">"35_dtk10_32358_5610_2_nw_col.<wbr>tif"<u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span 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.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">I guess that this is not the intended behaviour is it?<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span 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?<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span 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):<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier New"">C:\_PortableApps_\pgsql\bin>"<wbr>c:\QGIS\bin\gdalinfo.exe" PG:"dbname='xxx' host='localhost' port='5432' user='mhaerte2' password='xxx' table='raster2x2'"</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Driver: PostGISRaster/PostGIS Raster driver<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Files: none associated<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Size is 0, 0<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Coordinate System is:<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">PROJCS["ETRS89 / UTM zone 32N",<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> GEOGCS["ETRS89",<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> DATUM["European_Terrestrial_<wbr>Reference_System_1989",<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> SPHEROID["GRS 1980",6378137,298.257222101,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> AUTHORITY["EPSG","7019"]],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> TOWGS84[0,0,0,0,0,0,0],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> AUTHORITY["EPSG","6258"]],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> PRIMEM["Greenwich",0,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> AUTHORITY["EPSG","8901"]],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> UNIT["degree",0.<wbr>0174532925199433,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> AUTHORITY["EPSG","9122"]],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> AUTHORITY["EPSG","4258"]],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> PROJECTION["Transverse_<wbr>Mercator"],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> PARAMETER["latitude_of_origin"<wbr>,0],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> PARAMETER["central_meridian",<wbr>9],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> PARAMETER["scale_factor",0.<wbr>9996],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> PARAMETER["false_easting",<wbr>500000],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> PARAMETER["false_northing",0],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> UNIT["metre",1,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> AUTHORITY["EPSG","9001"]],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> AXIS["Easting",EAST],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> AXIS["Northing",NORTH],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> AUTHORITY["EPSG","25832"]]<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Subdatasets:<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> --- snip! --<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Corner Coordinates:<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Upper Left ( 0.0, 0.0)<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Lower Left ( 0.0, 0.0)<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Upper Right ( 0.0, 0.0)<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Lower Right ( 0.0, 0.0)<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Center ( 0.0, 0.0)<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Does anyone have a clue?
<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Thank you for your comments,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Michael<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><br>
______________________________<wbr>_________________<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/<wbr>mailman/listinfo/postgis-users</a><u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
<br>______________________________<wbr>_________________<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" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br></blockquote></div><br></div></div></div></div></div>