title: python sqlalchemy get column names dynamically?
body: <pre><code>#!/usr/bin/env python
  # -*- coding: utf-8 -*-
  
  from sqlalchemy import create_engine
  
  connection = create_engine('mysql://user:passwd@localhost:3306/db').connect()
  
  result = connection.execute("select * from table")
  for v in result:
          print v['id']
          print v['name']
  connection.close()
  </code></pre>
  
  <p>how i can get TABLES COLUMNS NAMES dynamically? in this case <code>id</code> and <code>name</code></p>