[R] Reading column names with spaces using dbGetQuery

Raji raji.sankaran at gmail.com
Wed Sep 28 02:18:43 CEST 2011


 I have been trying to read a dataset which has spaces in column names using
dbGetQuery from RJDBC.

* dataFrame<-dbGetQuery(conn,"select 'Sepal Length','Sepal Width' from
"326_1_Result")*
The resulting dataframe contains column names as 

"*Sepal.Length" "Sepal.Width" *

But i would like to maintain the spaces in column names as it is.Is there
any method is R similar to check.names=FALSE , which can be used in
dbGetQuery for maintaining the spaces in column names.

Thanks for your help.


--
View this message in context: http://r.789695.n4.nabble.com/Reading-column-names-with-spaces-using-dbGetQuery-tp3849597p3849597.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list