Message-ID: <48BC4EC8.3040209@stats.uwo.ca>
Date: 2008-09-01T20:21:28Z
From: Duncan Murdoch
Subject: SQL Primer for R
In-Reply-To: <50d1c22d0808311829i70d538a6j2b01eed47d9a0093@mail.gmail.com>
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