<div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Hi all,</div><div><br></div><div>Was wondering if someone has a similar experience.</div><div>I'm testing storing raster data in my PostGIS db as an 'out-db' option.</div><div>It seems to work via the raster2pgsql command line.</div><div>The table is generated and I can see the table thru the QGIS browser/DB Manager.</div><div>However, if I drag/drop onto the map I get nothing.</div><div>I can, however, zoom to the extents of the image....but I get no image appearing.</div><div>The image is a geotiff.</div><div>In-database option works fine.</div><div>I'm using QGIS v3.20.3-Odense with Postgresql 13.4 windows.</div><div>Has anyone had success managing their raster data like this and viewing in QGIS ?</div><div><br></div><div>My command to store out-db image is below:</div><div><pre class="gmail-lang-sql gmail-s-code-block" style="margin-top:0px;padding:12px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:1.30769;font-size:13px;vertical-align:baseline;box-sizing:inherit;width:auto;max-height:600px;overflow:auto;border-radius:5px"><code class="gmail-hljs gmail-language-sql" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit;background-color:transparent;white-space:inherit">raster2pgsql <span class="gmail-hljs-operator" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">-</span>s <span class="gmail-hljs-number" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">28350</span> <span class="gmail-hljs-operator" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">-</span>C <span class="gmail-hljs-operator" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">-</span>I <span class="gmail-hljs-operator" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">-</span>F “path\[image_name].tif" [schema1].[tablename] -R | psql -h localhost -d spatialDB -U postgres -p 5432</code></pre></div><div><br></div><div>thanks</div></div></div></div>