title: psycopg2 cannot find any tables after connection
body: <p>I can connect to my database, but psycopg2 fails to find any of my tables. The following will error trying to get my users:</p>
  
  <pre><code>import psycopg2
  
  try:
      conn = psycopg2.connect("dbname='pdb' user='postgres' host='localhost' password='password'")
  except:
      print 'failed to connect'
  
  cur = conn.cursor()
  cur.execute(""" SELECT * from Users """)
  rows = cur.fetchall()
  for row in rows:
      print row[0]
  
  #Error:
  psycopg2.ProgrammingError: relation "users" does not exist
  LINE 1: SELECT * from Users 
  
  # This also fails
  cur.execute("""SELECT * from pdb.Users """)
  </code></pre>
  
  <p>If I do:</p>
  
  <pre><code>cur.execute(""" SELECT * from pg_database """)
  
  # Outputs
  template1
  template0
  postgres
  pdb
  </code></pre>
  
  <p>In my admin panel, pdb shows a bunch of tables, one of them being <code>Users</code>, so I'm not sure why psycopg2 can't find it. </p>
  
  <p>Here's a printout from psql for <code>pdb</code>:</p>
  
  <pre><code>               List of relations
   Schema |        Name        | Type  |  Owner   
  --------+--------------------+-------+----------
   public | Companies          | table | postgres
   public | Users              | table | postgres
  (2 rows)
  </code></pre>