Hello,
Within a bigger loop, I want to write results to a table in Postgress,
the overwrite and append arguments are ignored and I end up with only the
current data in the table and the older data is overwritten.
My code is;
ifelse((dbExistsTable(con, "region_subgroup_mktseg")),
dbWriteTable(con, "region_subgroup_mktseg", results_tograph, append=TRUE,
overwrite=FALSE),
dbWriteTable(con, "region_subgroup_mktseg", results_tograph))
R.version
_
platform i386-pc-mingw32
arch i386
os mingw32
system i386, mingw32
status
major 2
minor 13.2
year 2011
month 09
day 30
svn rev 57111
language R
version.string R version 2.13.2 (2011-09-30)
Thank you
append=TRUE, overwrite=FALSE ignored in dbWriteTable
2 messages · Elinor Zeev, Tomoaki NISHIYAMA
Hi, Can you tell the PostgreSQL driver version? BTW, dbWriteTable(con, "region_subgroup_mktseg", results_tograph, append=TRUE) should work without prior check for dbExistTable.
Tomoaki NISHIYAMA Advanced Science Research Center, Kanazawa University, 13-1 Takara-machi, Kanazawa, 920-0934, Japan On 2011/10/27, at 7:58, Elinor Zeev wrote: > Hello, > Within a bigger loop, I want to write results to a table in Postgress, > > the overwrite and append arguments are ignored and I end up with only the > current data in the table and the older data is overwritten. > My code is; > > ifelse((dbExistsTable(con, "region_subgroup_mktseg")), > dbWriteTable(con, "region_subgroup_mktseg", results_tograph, append=TRUE, > overwrite=FALSE), > dbWriteTable(con, "region_subgroup_mktseg", results_tograph)) > > R.version > _ > platform i386-pc-mingw32 > arch i386 > os mingw32 > system i386, mingw32 > status > major 2 > minor 13.2 > year 2011 > month 09 > day 30 > svn rev 57111 > language R > version.string R version 2.13.2 (2011-09-30) > > Thank you > > [[alternative HTML version deleted]] > > _______________________________________________ > R-sig-DB mailing list -- R Special Interest Group > R-sig-DB at r-project.org > https://stat.ethz.ch/mailman/listinfo/r-sig-db >