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

[Osahon Oduware]

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 <osahon.gis at gmail.com>
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 <
> 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/05adb798/attachment.html>