[postgis-users] Can I change the path of an out-of-db raster?

guido lemoine guido.lemoine at jrc.ec.europa.eu
Tue Feb 10 02:34:38 PST 2015


Hmm, any thoughts on this? Just to expand my use case: I have a time series of images that are all spatially aligned, i.e. same size, geo-location, pixel spacing, projection.
Thus, raster2pgsql -R would always create the same tiled raster entries for each image where only the (binary) file name would be different. 
If one would simply be able to change the filename, a single set of tile records would be needed. That would be a neat concept for time series (other than creating massive multi-band images).

Something like ST_SetBandPath(rast, filepath) could be useful, although only in the aligned context. 

GL

On 02/06/15, guido lemoine  <guido.lemoine at jrc.ec.europa.eu> wrote:
> 
> 
> Dear List,
> 
> I have stored some rasters out-of-db (using raster2pgsql with the -R option). I have to move these rasters
> to another disk and wonder if there is a simple way to update the BandPath to the new location, other
> than dropping the tables and re-load with the new path. I see there is ST_BandPath, but not a corresponding
> ST_SetBandPath(). 
> 
> Thanks!
> 
> Guido
> 
> 
> 
> 
> 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150210/594a384e/attachment.html>


More information about the postgis-users mailing list