title: connecting form R (client) to Greenplum server
body: <p>I'm trying to retrieve data from greenplum cluster into R (win client).
  I've tried:</p>
  
  <pre><code>library("RODBC")
  conn &lt;- odbcDriverConnect("DSN_name")
  Sql &lt;- "select * from DB.st.country"
  cen_data &lt;- sqlQuery(conn,Sql)
  print(cen_data)
  </code></pre>
  
  <p>I'm getting error:
  0A000 7 ERROR: cross-database references are not implemented</p>
  
  <p>I have seen some answers about dblink but when I tried:
      sql &lt;- "select dblink_connect('conn', 'dbname=myDB');"
      cen_data &lt;- sqlQuery(conn,Sql)</p>
  
  <p>I'm getting error:
  "42883 7 ERROR: function dblink_connect(unknown, unknown) does not exist</p>
  
  <p>Does anyone have any idea what Am I doing wrong?</p>