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 <lrssv...@gmail.com>: > Thank you very much! > > -- > Sent from my mobile phone > > Il 01 Dic 2017 12:01 PM, "kimaidou" <kimai...@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-develo...@lists.osgeo.org >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user