Good morning Michaël, Loïc,
Add PostGIS Table(s) dialogue already shows our spatial enabled tables.
We might just add another column to show if that geometry column is
already indexed or not. We can add another action button to create it,
enabled if missing.
I've added a very simple mockup in th
Hi,And what about some snippets/useful query in DB manager like pgModeler ? Regards.Loïc.
Hi Jorge
This feature would be good to have in the DB manager, but I do not think we
should create a function in any database without warning the user.
Inside QGIS, we should be less intrusive and only run the SELECT SQL inside
the function to get all missing indexes, show them in a QGIS table vi
Nice contribution, Michaël! Tested and approved :-)
We might use this query to offer the option "Check missing spatial
indexes" in DB Manager, with an additional checkbox to "Add missing
indexes". Initially just for the Postgis provider, but it can be
implemented for other providers.
What do you
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 c
Thank you very much!
--
Sent from my mobile phone
Il 01 Dic 2017 12:01 PM, "kimaidou" 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 c
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