Displaying 1 result from an estimated 1 matches for "connae1".
Did you mean:
conna
2012 Jun 12
1
Not able to write to PostgreSQL database using "dbWriteTable"
...ng to write some data ( i=
6) to PostgreSQL database, but it not writing.
Is there any issue in the way I use "dbWriteTable"?
++++++++++++++++++ Source Code ++++++++++++++++++++++++
library("DBI")
library("RPostgreSQL")
drv1 <- dbDriver("PostgreSQL")
i=6
connAE1 <- dbConnect(drv1,host = "xx.xxx.xxx.xxx", port = "6443",
dbname="DB",user = "xxxxx",password = "xxx")
as.data.frame(zz[1])
dbGetQuery(connAE1,'SELECT id FROM \"test1\"')
if(dbExistsTable(connAE1, "test1")){
dbWrit...