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

Osahon Oduware osahon.gis at gmail.com
Thu Jul 13 04:36:46 PDT 2017


Hi Hugues,

I would try this out and give you feedback. Thanks.

On Thu, Jul 13, 2017 at 12:32 PM, Hugues François <hugues.francois at irstea.fr
> 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 <osahon.gis at gmail.com> 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 <
> hugues.francois at irstea.fr> 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 <osahon.gis at gmail.com> 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
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170713/0244121d/attachment.html>


More information about the postgis-users mailing list