[BioC] pdInfoBuider: how to view SQL scheme?

[Benilton Carvalho]

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
>