Re: [R] SQL Primer for R

From: Duncan Murdoch <>
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 mailing list PLEASE do read the posting guide 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 Please read the posting guide before posting to the list.

list of date sections of archive