title: PostgreSQL column 'foo' does not exist
body: <p>I have a table that has 20 integer columns and 1 text column named 'foo'</p>
  
  <p>If I run query:</p>
  
  <pre><code>SELECT * from table_name where foo is NULL
  </code></pre>
  
  <p>I get error:</p>
  
  <pre><code>ERROR:  column "foo" does not exist
  </code></pre>
  
  <p>I have checked myself that his column indeed exists. If I do something like:</p>
  
  <pre><code>SELECT * from table_name where count is NULL
  </code></pre>
  
  <p>The resulting output shows 'foo' as one of the columns....
  I am guessing I have to do something special in the query because foo is a text column...</p>
  
  <p>Thanks for the help (POSTGRESQL 8.3)</p>