Dear R-DB users,
I have a problem in accessing postgresql from r.
I can only use library(RDOBC), because the drivers for postgresql (RdbiPgSQL)
from DBI are not available in windows (does anyone has tham?), so, using th ODBC...
library(RDOBC)
chanel1=odbcDriverConnect("DRIVER=PostgreSQL; DBQ=campanhas") # it connects
sqlTables(chanel1, "tbl_taxon")
[1] "[RODBC] ERROR: Could not SQLExecDirect"
[2] "S1000 7 ERROR: relation \"tbl_taxon\" does not exist"
So, it does not access the data, although it knows that the table is there!!!
However, it does the connection with access or excell well
Thank you very much in advance,
Any light will be strongly apretiates,
Best wishes,
Marta
PS: I am working on a windows XP professional and R 2.1, postgresql 8.0.