title: writing tables to Postgresql using rPostgreSQL when the database name is all capital letters
body: <p>I have a database in PostgreSQL which is named <code>DATA</code> in all caps. When I try to write an R data.frame to this database using RPostgreSQL like so:</p>
  
  <pre><code>library(RPostgreSQL)
  con &lt;- dbConnect(PostgreSQL(), host="myhost", 
                   user= "postgres", password="myPass", dbname="DATA")
  dbWriteTable(con, "test", myDf)
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  no schema has been selected to create in
  )
  [1] FALSE
  </code></pre>
  
  <p>However I notice that if I go to Postgresql and change the database name to <code>data</code> (lower case) and then change the script to call <code>dbname="data"</code> then it works like a charm. </p>
  
  <p>I looked through the documentation for rPostgreSQL and the only mention of case I saw had to do with field names being case sensitive. </p>
  
  <p>So my questions are:</p>
  
  <ol>
  <li>Is this behavior is expected?</li>
  <li>In my situation I control the DB so I can rename the database at will. How would I work around this behavior if I could not rename the database to all lower case?</li>
  </ol>