title: How to cast date to string in psycopg2?
body: <p>I'm sure it has something to do with registering custom type cast as described <a href="http://initd.org/psycopg/docs/advanced.html#type-casting-from-sql-to-python" rel="nofollow">here</a>. However, I'm not sure how to do that.</p>
  
  <p>What I want to do is something like this:
  <code>SELECT * FROM table</code>
  and where a column is of <code>date</code> type, I want psycopg2 to convert it to Python string instead of datetime.</p>