Using -s and -R together in raster2pgsql transforms raster data instead of setting srid

[robe]

I haven't tested this myself, but on postgis users list, two people mentioned this behavior:

​https://lists.osgeo.org/pipermail/postgis-users/2017-April/042020.html

2017-04-11 14:25 GMT+02:00 Tumasgiu Rossini <rossini.t at gmail.com>:

> Hi,
>
> I think I found the probelm, it is the -s option which make the sql
> applying a st_transfrom on the raster to reproject it into the desired CRS
> before inserting it in the table, thus creating an in-db raster.
>

As Pierre noted, best thing to do is use the same reprojection syntax and shp2pgsql -s from_srid:to_srid (this might work already) have to test. and forbit transform with out-db. Since there is no point if its going to end up being in-db.

​https://lists.osgeo.org/pipermail/postgis-users/2017-April/042050.html