title: psql column doesn't exist but it does
body: <p>I am trying to select a single column in my data table using raw SQL in a postgresql database from the psql command line.  I am getting an error message that says the column does not exist.  Then it gives me a hint to use the exact column that I referenced in the select statement.  Here is the query:</p>
  
  <pre><code>SELECT insider_app_ownershipdocument.transactionDate FROM insider_app_ownershipdocument;
  </code></pre>
  
  <p>Here is the error message:</p>
  
  <pre><code>ERROR:  column insider_app_ownershipdocument.transactiondate does not exist
  SELECT insider_app_ownershipdocument.transactionDate FROM in...
  HINT:  Perhaps you meant to reference the column "insider_app_ownershipdocument.transactionDate".
  </code></pre>
  
  <p>I have no idea why this is not working.</p>