374def make_sql_create_gist(table, column):
375 gist_table = make_sql_table_name(table)
376 target_table = make_sql_full_table_name(table)
377 logit("MSG: Create GiST spatial index on %s\n" % gist_table)
378
379 sql = "CREATE INDEX \"%s_%s_gist_idx\" ON %s USING GIST (st_convexhull(%s));\n" % \
380 (gist_table, column, target_table, column)
381 logit("SQL: %s" % sql)
382 return sql;
383
384