381def make_sql_create_gist(table, column):
382 gist_table = make_sql_table_name(table)
383 target_table = make_sql_full_table_name(table)
384 logit("MSG: Create GiST spatial index on %s\n" % gist_table)
385
386 sql = "CREATE INDEX \"%s_%s_gist_idx\" ON %s USING GIST (st_convexhull(%s));\n" % \
387 (gist_table, column, target_table, column)
388 logit("SQL: %s" % sql)
389 return sql;
390
391