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

[Osahon Oduware]

Hi,

As a follow-up on this subject, I want to point out something 'strange' I
discovered with Rasters using mixed-case (lowercase and uppercase) in the
table names - QGIS takes like forever to load them. Whereas Rasters with
lowercase table names (that are loaded with the same parameters/options as
those with mixed-case table names using the raster2pgsql tool) load very
fast on QGIS.

Has anyone had similar experience? Can someone explain why this great
difference in performance between mixed-case and lowercase raster table
names and any possible workarounds. The preference for my project is
mixed-case raster table names.

*NB:* You need to test with a fairly large raster set to determine the
performance difference.

On Fri, Jul 14, 2017 at 1:47 PM, Osahon Oduware <osahon.gis at gmail.com>
wrote:

> Hi Mateusz,
>
> I agree with you. Thanks a lot.
>
> On Fri, Jul 14, 2017 at 1:36 PM, Mateusz Loskot <mateusz at loskot.net>
> wrote:
>
>> On 14 July 2017 at 14:27, Osahon Oduware <osahon.gis at gmail.com> wrote:
>> > Hi Mateusz,
>> >
>> > I have just tried using the -q option and it works. Thanks a lot. I have
>> > gone through the doc a lot to resolve several issues in the past. In
>> this
>> > case it was an oversight as I thought that explicitly wrapping the
>> > identifiers in quote would give the same result as the -q option.
>>
>> raster2pgsql is modelled after shp2pgsql, in terms of capabilities,
>> so you shouldn't need any quoting/escaping gymnastics to tell the loaders
>> what case of names you want.
>>
>> It might have been easier if raster2pgsql used -k as shp2pgsql does,
>> but -k is taken by different option.
>>
>> raster2pgsql docs on -q could have been clearer though.
>> Patches are welcome.
>>
>> Best regards,
>> --
>> Mateusz Loskot, http://mateusz.loskot.net
>> _______________________________________________
>> 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/20180321/05a38d49/attachment.html>