R help - Sep 2009 - RSQLite column names underscores

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

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