Make simple CREATE TABLE from the first line of a tab-delimited data file

gistfile1.py

# Put this in a file and run it like "python yourscript.py name_of_your_file.csv".
import sys
import csv

csv_file_obj = csv.reader(open(sys.argv[1], "rb"), dialect=csv.excel_tab)
first_row = csv_file_obj.next()
# first_row is now a list of column names, we hope.  Feel free to print it out.
print "CREATE TABLE tablename (%s);" % (", ".join("%s TEXT" % (name,) for name in first_row),)