title: WHERE Statement Throwing Error using VARCHAR
body: <p>I am using the DBI package with the RPostgreSQL driver to query from an amazon redshift database and am able to pull tables with simple queries without issue. By simple queries I mean something like this:</p>
  <pre><code>'SELECT * FROM transactions ORDER BY timestamp DESC LIMIT 200' 
  </code></pre>
  <p>When I use a WHERE statement on a field that has a type FLOAT8, again, no issue. Queries such as:</p>
  <pre><code>'SELECT * FROM transactions ORDER BY timestamp WHERE transaction_amt &lt; 5 DESC LIMIT 200' 
  </code></pre>
  <p>The issue arises when trying to use a WHERE statement with a field that has a type VARCHAR. A query such as:</p>
  <pre><code>'SELECT * FROM transactions ORDER BY timestamp WHERE type = 'Credit Card' DESC LIMIT 200' 
  </code></pre>
  <p>Gives me an error that says:</p>
  <pre><code>Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  column &quot;credit card&quot; does not exist in transactions
  )
  </code></pre>
  <p><br />
  <br />
  My question is if there is some specific syntax when using WHERE statements with these packages or this specific database. Why would it tell me that the column 'credit card' doesn't exist?</p>
  <p>When looking at the information about each field I did see that 'type' and many other character columns have a Len of -1, could that have something to do with it?</p>