[postgis-users] Raster Table Name With Upper-Case Characters

Mateusz Loskot mateusz at loskot.net
Fri Jul 14 04:10:00 PDT 2017


On 14 July 2017 at 12:44, Osahon Oduware <osahon.gis at gmail.com> 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


More information about the postgis-users mailing list