361def make_sql_create_table(options, table = None, is_overview = False):
362
363 if table is None:
364 table = options.table
365
366 if options.filename:
367 sql = "CREATE TABLE %s (rid serial PRIMARY KEY, \"filename\" text);\n" \
368 % (make_sql_full_table_name(table))
369 else:
370 if options.overview_level > 1 and is_overview:
371 sql = "CREATE TABLE %s (rid serial PRIMARY KEY, %s RASTER);\n" \
372 % (make_sql_full_table_name(table), quote_sql_name(options.column))
373 else:
374 sql = "CREATE TABLE %s (rid serial PRIMARY KEY);\n" \
375 % (make_sql_full_table_name(table))
376
377 logit("SQL: %s" % sql)
378 return sql
379
380