[QGIS-Developer] Fwd: My PostgreSQL/PostGIS function to create all missing spatial indexes

[kimaidou]

I have improved my function.

Now it returns a table containing the schema, table name and column name.
You need to use it with
SELECT * FROM create_missing_spatial_indexes();

If you would like to only get the informations about missing indexes, there
is a new "simulate" parameter.
SELECT * FROM create_missing_spatial_indexes(True);

URL : https://gist.github.com/mdouchin/cfa0e37058bcf102ed490bc59d762042

Cheers,
Michaël

2017-12-01 12:10 GMT+01:00 Salvatore Larosa <lrssvtml at gmail.com>:

> Thank you very much!
>
> --
> Sent from my mobile phone
>
> Il 01 Dic 2017 12:01 PM, "kimaidou" <kimaidou at gmail.com> ha scritto:
>
>> Hi users and devs,
>>
>> I just created a very simple function [1] to create all the missing
>> spatial indexes on your table geometry columns.
>>
>> It is the 1st version, has no fancy parameter to choose tables or
>> schemas, nor return anything usefull (only notices).
>>
>> Use it with a simple
>> SELECT create_missing_spatial_indexes();
>>
>> [1] https://gist.github.com/mdouchin/cfa0e37058bcf102ed490bc59d762042
>>
>> Regards,
>> Michael
>>
>>
>> _______________________________________________
>> QGIS-Developer mailing list
>> QGIS-Developer at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20171201/c78271b5/attachment.html>