[postgis-users] Exporting raster table into a file

[Pierre Racine]

If your raster fits on one row you can ST_Union() it before using lo_export as described in 

http://gis.stackexchange.com/questions/78086/how-to-export-raster-from-postgis-enabled-db-as-gtiff-with-gdal-translate

You can load a PostGIS Raster in QGIS with the DB Manager.

See http://gis.stackexchange.com/questions/76297/loading-postgis-raster-layer-into-qgis

Pierre

> -----Original Message-----
> From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> bounces at lists.osgeo.org] On Behalf Of DanielFranco
> Sent: Thursday, September 04, 2014 11:06 AM
> To: postgis-users at lists.osgeo.org
> Subject: [postgis-users] Exporting raster table into a file
> 
> I'm reclassifying a landsat image in PostGIS 2.0 using the ST_Reclass
> function in a big raster (size about 50000x70000) and I'm trying to check
> the results in the new raster table I created that contains the reclassified
> raster. So, I decided to export the raster table to a file to check the
> results, but gdal_translate is taking too much time to export (1 hour and
> progress is in 40%). The command I'm using is:
> 
> gdal_translate -of GTiff --config GDAL_CACHEMAX 512 "PG:host='localhost'
> dbname='raster' user='postgres' password='postgres' schema='public'
> table='mosaic' mode='2' " new_raster_directory.tif
> 
> Is there a way to export the whole image faster? It seems like the
> "\lo_export thing" only exports tiles of the raster, but i'm not sure about
> that. Is there an easier way to visualize the raster without exporting? I
> heard that QGIS has an plugin for that, but someone can tell me that it is
> good/fast/etc?
> 
> 
> 
> --
> View this message in context: http://postgis.17.x6.nabble.com/Exporting-
> raster-table-into-a-file-tp5006986.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users