You are probably trying to use SQL reserved keywords as column names. Try entering this at the R prompt:
library(RSQLite) .SQL92Keywords On Sun, Sep 27, 2009 at 5:25 PM, Christopher Bare <cb...@systemsbiology.org> wrote: > Hi, > > When I use RSQLite's dbWriteTable(...) function, the columns in the db > table frequently end up having "__1" (two underscores and a one) added > to them. The names are unique within the table and contain no weird > characters. For example a "position" column from a data.frame was > written to the DB as "position__1". > > Does anyone understand how this name munging happens and how I can > prevent or work around it? Having these suffixes added seemingly > arbitrarily makes it hard to construct the next query. > > Thanks for any hints, > > -chris > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.