Skip to content

dbGetQuery and options(stringsAsFactors=F)

1 message · Dinesh

#
Is there some configuration to make dbGetQuery() pick up defaults set 
via options() call? E.g.,

require(RpgSQL);
options(stringsAsFactors=F);
...
x=dbGetQuery(dbConnect(pgSQL()), "select * from some_table");
is.factor(x[1,"stringcol"]) # returns TRUE
#OTOH
x=dbGetQuery(dbConnect(pgSQL()), "select * from 
some_table",stringsAsFactors=F);
is.factor(x[1,"stringcol"]) # returns FALSE

I am using RpgSQL 0.1-5 with RJDBC 0.2.