title: Why can I not read my table although it is listed by dbListTables?
body: <p>I am trying to read a table into R using RPostgreSQL and R v2.14.2.<br>
  My version of RPostgreSQL is listed as 0.3-2, downloaded 16-May-2012.<br>
  My version of DBI is listed as 0.2-5, downloaded 16-May-2012.</p>
  
  <p>I can open the database, and list the tables. The table I want to open is clearly present, however, when I try to read it, I get an error message. I am unsure if the error is in my code or in the way the database is set up.</p>
  
  <pre class="lang-r prettyprint-override"><code>library(RPostgreSQL)  
  # Loading required package: DBI  
  drv &lt;- dbDriver("PostgreSQL")  
  con &lt;- dbConnect(drv, host = 'freda.freda.com', dbname = 'test', user = 'fredak', password = 'xxxx')  
  
  dbListTables(con)  
  # [1] "chemistry”                                               
  # [2] "ecog”  
  # [3] "hematology"                                        
  
  dbExistsTable(con, "ecog")  
  # [1] FALSE
  
  MyTable &lt;- dbReadTable(con, "ecog")    
  # Error in postgresqlExecStatement(conn, statement, ...) :  
  #   RS-DBI driver: (could not Retrieve the result : ERROR:  relation "ecog" does not exist  
  # LINE 1: SELECT * from "ecog"  
  #                       ^  
  # )  
  # Error in names(out) &lt;- make.names(names(out), unique = TRUE) :   
  #   attempt to set an attribute on NULL  
  # In addition: Warning message:  
  # In postgresqlQuickSQL(conn, statement, ...) :  
  #   Could not create executeSELECT * from "ecog"
  </code></pre>