[BioC] pdInfoBuider: how to view SQL scheme?

Benilton Carvalho beniltoncarvalho at gmail.com
Fri Apr 23 18:37:06 CEST 2010


actually, the following may suffice:

dbGetQuery(conn, "select name, sql from sqlite_master where type='table'")

b

On Fri, Apr 23, 2010 at 5:30 PM, Benilton Carvalho
<beniltoncarvalho at gmail.com> wrote:
> you'd need to go to the cli and use sqlite directly:
>
> .schema table
>
> the following may also be useful (from R):
>
> f = function(tbl, conn)
>  dbGetQuery(conn, gsub("TABLE", tbl, "pragma table_info (TABLE)"))
> tbls = dbListTables(conn)
> res = lapply(tbls, f, conn)
> names(res) = tbls
>
> b
>
> On Fri, Apr 23, 2010 at 4:51 PM, Hooiveld, Guido <Guido.Hooiveld at wur.nl> wrote:
>> Hi all,
>> Likely an easy answer, but i just don't know:
>> How to look at the underlying SQL scheme from e.g. the platform design info packages created by pdInfoBuilder, such as e.g. pd.mogene.1.1.st.v1??
>>
>> I tried with:
>> conn <- db(object)
>> sql <- "DESC FROM pmfeature"
>> dbGetQuery(conn, sql)
>>
>> Error in sqliteExecStatement(con, statement, bind.data) :
>>  RS-DBI driver: (error in statement: near "DESC": syntax error)
>>
>> but that thus doesn't work...
>>
>> Thanks,
>>
>> Guido
>>
>> ------------------------------------------------
>> Guido Hooiveld, PhD
>> Nutrition, Metabolism & Genomics Group
>> Division of Human Nutrition
>> Wageningen University
>> Biotechnion, Bomenweg 2
>> NL-6703 HD Wageningen
>> the Netherlands
>> tel: (+)31 317 485788
>> fax: (+)31 317 483342
>> internet:   http://nutrigene.4t.com<http://nutrigene.4t.com/>
>> email:      guido.hooiveld at wur.nl
>>
>>
>>
>>        [[alternative HTML version deleted]]
>>
>> _______________________________________________
>> Bioconductor mailing list
>> Bioconductor at stat.math.ethz.ch
>> https://stat.ethz.ch/mailman/listinfo/bioconductor
>> Search the archives: http://news.gmane.org/gmane.science.biology.informatics.conductor
>>
>



More information about the Bioconductor mailing list