[R] RSQLite equivalent of .schema?

2010-05-12 Thread Jonathan Greenberg
Rhelpers:

(Thanks for the previous help with getting a where statement
working).  Now on to my next question -- our database guru has asked
me to run .schema on an sqlite database, and I was wondering if
there is an equivalent in R to do this?  Thanks!

--j

__
R-help@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.


Re: [R] RSQLite equivalent of .schema?

2010-05-12 Thread Seth Falcon

On 5/12/10 9:58 AM, Jonathan Greenberg wrote:

Rhelpers:

(Thanks for the previous help with getting a where statement
working).  Now on to my next question -- our database guru has asked
me to run .schema on an sqlite database, and I was wondering if
there is an equivalent in R to do this?  Thanks!


dbGetQuery(db,
   select * from sqlite_master where tbl_name = 'yourTable')


--
Seth Falcon | @sfalcon | http://userprimary.net/

__
R-help@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.