On 14 July 2017 at 12:44, Osahon Oduware <[email protected]> wrote: > > Thanks for your suggestion. I would attempt this on a small raster and give > you feedback. However, in practice I am working with a large raster, hence, > I am piping the output of the raster2pgsql command with the connection to > the database as below: > raster2pgsql -s <SRID> -d -Y -e -I -C -F -M /path/to/raster/file > <RASTER_TABLE> | psql -h localhost -U postgres -p 5432 -d <database> >
If you scanned the docs you would have learned about -q option. (reading PostgreSQL docs on quoted identifiers might be useful too). If quoted identifiers are not requested, raster2pgsql forces database object names (schema/table...) to lowercase. Best regards, -- Mateusz Loskot, http://mateusz.loskot.net _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
