I have added the Raster support to my PostGIS database program. Now, I need to update all values in the raster (one band only) several times a day.
I have found and tested these two options
- Use WKB and do
UPDATE table SET rast = 'wkb_data_string';(code extracted from http://www.postgis.org/documentation/raster-doxygen/dd/d23/rt__api_8c-source.html)
Both methods works fine with same results, speeds according to my tests seems also almost the same (but I may have done some errors there).
What is a better way from those twos, or is there some third option?