Re: [R] SQL Primer for R

From: Duncan Murdoch <murdoch_at_stats.uwo.ca>
Date: Mon, 01 Sep 2008 16:21:28 -0400

ivo welch wrote:
> stumped again by SQL... If I have a table named "main" in an SQLite
> data base, how do I get the names of all its columns? (I have a mysql
> book that claims the SHOW command does this sort of thing, but it does
> not seem to work on SQLite.)
>
If you are using RSQLite, then a lot of the obscure commands are available as R functions. In this case I think you want sqliteTableFields.

Duncan Murdoch



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. Received on Mon 01 Sep 2008 - 20:24:29 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 01 Sep 2008 - 20:34:52 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive