Hi Hugues, 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>
On Fri, Jul 14, 2017 at 8:51 AM, Hugues François <[email protected]> wrote: > Hi, > > I did some test using shp2pgsql because I didn't have available raster > data on the computer I use from my holidays place. > > It seems that it changes upper to lower case and already uses double > quotes. Maybe, you coud try to proceed in several steps: first saving the > output file of raster2pgsql, then uses sed to change its content with the > correct syntax and finally uses psql command to execute le sql command file. > > Regards, > > Hug > > > > ------------------------------ > *De: *"Osahon Oduware" <[email protected]> > *À: *"PostGIS Users Discussion" <[email protected]> > *Envoyé: *Jeudi 13 Juillet 2017 14:41:27 > *Objet: *Re: [postgis-users] Raster Table Name With Upper-Case Characters > > Hi Hugues, > > Using the backslash to escape the quotes as you suggested produces a > syntax error. > > On Thu, Jul 13, 2017 at 12:36 PM, Osahon Oduware <[email protected]> > wrote: > >> Hi Hugues, >> >> I would try this out and give you feedback. Thanks. >> >> On Thu, Jul 13, 2017 at 12:32 PM, Hugues François < >> [email protected]> wrote: >> >>> Yes, that's what I mean. I didn't try it but I think you need to tell >>> raster2pgsql that double quotes are part of the string and not a simple >>> text delimiter. >>> >>> It could look like something like this: >>> raster2pgsql raster_options_go_here raster_file someschema.\"sometable\" >>> >>> Hug >>> >>> Le 13 juil. 2017 1:13 PM, Osahon Oduware <[email protected]> a >>> écrit : >>> >>> Hi Hugues, >>> >>> Thanks for your response. Do you mean escape with a backslash as is done >>> with most programming languages? Please, provide an example. >>> >>> On Thu, Jul 13, 2017 at 11:27 AM, Hugues François < >>> [email protected]> wrote: >>> >>> Hi, >>> >>> Did you try to escape double quotes in the raster2pgsql command line ? >>> >>> Regards, >>> Hug >>> >>> >>> Le 13 juil. 2017 12:21 PM, Osahon Oduware <[email protected]> a >>> écrit : >>> >>> Hi All, >>> >>> *I wanted to know if there is a way to specify a raster table name with >>> Upper-Case characters using the raster2pgsql tool*. I have tried >>> enclosing the table name in double-quotes, but the raster2pgsql tool seems >>> to convert it to Lower-Case characters. >>> >>> Knowing how to do this would save me from the current challenge of >>> renaming the raster table after they have been created (see the link below): >>> Renaming Raster Table >>> <https://groups.google.com/forum/#!searchin/postgis-users/Renaming$20Raster$20Table%7Csort:relevance/postgis-users/MKI7pvko6q0/Oqfqw9nUBAAJ> >>> >>> I would be glad if someone could help me with this. >>> >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> >>> >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> >> >> > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
