title: Psycopg2 cursor.execute return a generator
body: <p>Say i have only 1GB of memory and 1 TB of hard disk space. </p>
  
  <p>This is my code and i am using a postgres database. </p>
  
  <pre><code>import psycopg2
  
  try:
     db = psycopg2.connect("database parameters")
     conn = db.cursor()
     conn.execute(query) 
  
     #At this point, i am running 
     for row in conn:
  </code></pre>
  
  <p>for this case, I guess it is safe to assume that conn is a generator as i cannot seem to find a definitive answer online and i cannot try it on my environment as i cannot afford the system to crash. </p>
  
  <p>I am expecting this query to return data in excess of 100 GB </p>
  
  <p>I am using python 2.7 and psycopg2 library</p>