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