[R] RSQLite column names underscores

[Gabor Grothendieck]

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
<cbare at 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 at 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.
>