[R-sig-DB] append=TRUE, overwrite=FALSE ignored in dbWriteTable
Elinor Zeev
ezeevt|v @end|ng |rom gm@||@com
Thu Oct 27 00:58:54 CEST 2011
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]]
More information about the R-sig-DB
mailing list