[R-sig-DB] SQL escaping/quoting proposal

Hadley Wickham h@w|ckh@m @end|ng |rom gm@||@com
Tue Oct 22 14:56:51 CEST 2013


> I've cleaned up the examples and made them work and put the results in
> https://gist.github.com/hadley/7057387 - that should make discussion a
> bit more concrete.

I made a few more changes to https://gist.github.com/hadley/7057387

* the method is now based on the connection, not the driver, since for
some drivers the escaping may vary between connections (e.g. ODBC)

* I added a sample tableName function (which I don't think would be
included in DBI), showing how you might accept multiple forms of table
names, and do the right thing as much as possible.

Hadley

-- 
Chief Scientist, RStudio
http://had.co.nz/




More information about the R-sig-DB mailing list