[BioC] Rdbi.PgSQL

[Sean Davis]

Hrishi,

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

Hope this helps,
Sean

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