[BioC] Rdbi.PgSQL

Sean Davis sdavis2 at mail.nih.gov
Mon Mar 21 16:20:58 CET 2005


RdbiPgSQL just interacts with the Postgresql database.  Your best source of 
information about working with postgresql is the postgres home page and the 
documenation.  As far as I know, you can't timestamp a simple SQL select 
statement, but you could make a stored procedure that, when called, does the 
query and puts a timestamp into some table.  This will require working 
directly with postgresql to define such a procedure (should be pretty 
simple) rather than through R.  Once the stored procedure is created, you 
can call it from R easily by doing something like:

dbGetQuery(con,'select * from mystoredprocedure()')

There is a VERY active postgresql community available via the webpage and 
email lists--you might find it interesting and helpful to move some of your 
postgres-type questions to those lists.  RdbiPgSQL is really good at getting 
results of queries, but much more complex activities can be performed within 

Hope this helps,

----- Original Message ----- 
From: "Hrishikesh Deshmukh" <d_hrishikesh at yahoo.com>
To: <bates at wisc.edu>
Cc: <bioconductor at stat.math.ethz.ch>
Sent: Monday, March 21, 2005 10:00 AM
Subject: Re: [BioC] Rdbi.PgSQL

> Hi All,
> Can one "timestamp" each query which i run via R
> against postgresql! Also can i plot (graphs) results
> for a query say:
> "select * from IntensityTable and plot histogram of
> the result"
> Where can i get vignettes/working examples for
> RdbiPgSQL!
> This package is really exiting!
> Thanks,
> Hrishi
> --- Douglas Bates <bates at stat.wisc.edu> wrote:
>> Hrishikesh Deshmukh wrote:
>> > Hi,
>> >
>> > I am using Debian linux, i use apt-get to install
>> > postgresql and installation is all done by apt-get
>> > install command! Any pointers how to find
>> postgresql
>> > client libs on debian!
>> >
>> > Thanks,
>> > Hrishi
>> >
>> apt-get install libpgsql2
> _______________________________________________
> Bioconductor mailing list
> Bioconductor at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/bioconductor

More information about the Bioconductor mailing list