title: Can dplyr access a POSTGRES 9.3.5 VIEW?
body: <p>My R (v. 3.1.1) dplyr (v. 0.3.0.2) can access my POSTGRES 9.3.5 TABLE, but not my VIEW in same database.</p>
  
  <p>Does dplyr support access a POSTGRES 9.3.5 VIEW?</p>
  
  <p>In POSTGRES my VIEW is defined like this:</p>
  
  <pre><code>centralstats=# \d "nicStats5"
             View "public.nicStats5"
      Column    |       Type        | Modifiers
  --------------+-------------------+-----------
   affectedId   | integer           |
   timeRecorded | bigint            |
   dn           | character varying |
   bytesRx      | bigint            |
  </code></pre>
  
  <p>View definition:</p>
  
  <pre><code> SELECT "adaptorNICVnicStats"."affectedId",
      "adaptorNICVnicStats"."timeRecorded",
      "affectedId2Dn".dn,
      "adaptorNICVnicStats"."bytesRx"
     FROM "adaptorNICVnicStats",
      "affectedId2Dn"
    WHERE "adaptorNICVnicStats"."affectedId" = "affectedId2Dn"."affectedId";
  </code></pre>
  
  <p>IN R All the databases, which my VIEW is defined upon, can be accessed from dplyr. 
  And the access to my VIEW fails as shown below:</p>
  
  <pre><code>centralstats &lt;- src_postgres("centralstats",host = NULL, port = NULL,"postgres","Jmu2014!")
  adaptorNICVnicStats &lt;-tbl(centralstats, "adaptorNICVnicStats")
  affectedId2Dn &lt;-tbl(centralstats, "affectedId2Dn")
  nicStats5 &lt;-tbl(centralstats, "nicStats5")
  ## Fejl: Table nicStats5 not found in database  //* COMMENT: "Fejl" is the Danish word for ERROR
  </code></pre>