Re: [R] RSQLite column names underscores

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 wrote: > Hi, > > When I use RSQLite's dbWriteTable(...) function, the columns in the db > table frequently en

[R] 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