[BioC] pdInfoBuider: how to view SQL scheme?

[James W. MacDonald]

Hi Guido,

Hooiveld, Guido 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)

I don't think SQL*Plus commands will necessarily work with SQLite. I 
also don't see an easy way from within R to get the schema, but it is 
easy enough directly from SQLite:

sqlite> .schema pmfeature
CREATE TABLE pmfeature (fid INTEGER, fsetid INTEGER REFERENCES 
featureSet(fsetid
), atom INTEGER, x INTEGER, y INTEGER);

Best,

Jim


> 
> 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

-- 
James W. MacDonald, M.S.
Biostatistician
Douglas Lab
University of Michigan
Department of Human Genetics
5912 Buhl
1241 E. Catherine St.
Ann Arbor MI 48109-5618
734-615-7826
**********************************************************
Electronic Mail is not secure, may not be read every day, and should not be used for urgent or sensitive issues