[raster] raster2pgsql: load a raster as a band(s) of an existing raster

[chdemars]

It would be nice to be able to load a raster as a band of an existing raster table. For instance, landsat data comes with each band a separate single band raster. I am currently loading each band as a separate table, merging them into a multi-band raster using AddBand?, then removing the individual band tables. Seems like a kludgy way to do a common task.

[dustymugs]

raster2pgsql does not have any connection to the database to verify that there is a raster (and the raster's attributes) to append to. It would need access to the database to even check which raster the new band should be added to (especially for tiles).

The lack of database connection is by design (specifically following the design and behavior of shp2pgsql).

[pracine]

What would be possible however is to have an extra option to "interpret 1, 2, 3, or 4 '#' characters in wildcard based input filenames as a search for band numbers and load corresponding bands as a one multiple band raster"...

Would not be possible to append to existing rasters, but would be able to load landsat easily.

[dustymugs]

Could you provide an example of this wildcarding?

[pracine]

*_l7_##_utm19.tif

## would be 01, 02, 03, 04, 05, 06...

[dustymugs]

That probably won't work. The filenames (and usage of wildcards) are depending upon the environment in which raster2pgsql is called. As for pulling specific bands, -b already exists for that purpose.