Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Why can I not read my file (using RPostgreSQL) if it is listed using dbListTables
- R> library(RPostgreSQL)
- Loading required package: DBI
- R> drv <- dbDriver("PostgreSQL")
- R> con <- dbConnect(drv, dbname="beancounter", user="edd", password="xxxxxx")
- R> dbListTables(con)
- [1] "beancounter" "cash" "fxprices" "indices" "meta"
- [6] "portfolio" "portfoliosold" "stockinfo" "stockprices"
- R> dbExistsTable(con, "cash")
- [1] TRUE
- R> dbExistsTable(con, 'cash')
- [1] TRUE
- R> dbExistsTable(con, 'Cash')
- [1] FALSE
- R> dbExistsTable(con, "Cash")
- [1] FALSE
- R> ccc <- dbReadTable(con, "cash")
- R> dim(ccc)
- [1] 24 7
- R>
Add Comment
Please, Sign In to add comment