执行数据库的describe命令

def describe(connection, tablename):
cur =connection.cursor()
cur.execute('select * from %s where 1=0' % tablename)
for desc in cur.description:
column_name = desc[0]
nullable = desc[6]
data_type = desc[1].__name__
data_length = desc[3]
print column_name, nullable, data_type, data_length