[BioC] RdbiPgSQL: slowness in dbWriteTable

[John Zhang]

>
>Yup, your method is essentially what I came across yesterday afternoon,
>with some slight variations.  What you outline is a bit better
>though.  This works for my immediate task, although I'm going to need a
>way to allow this to be automated (hopefully within RdbiPgSQL
>itself).  COPY won't work, and /copy of course needs to be called from
>psql.  One thought was to try and get /copy implemented in R.
>


Hi, jeff,

Have you tried to do copy in plain sql within RdbiPgSQL? e. g. 

> sql <- "copy yourDBName from 'yourFileName' using delimiters 'yourDelimiters'"
> dbSendQuery(yourConnection, sql)  



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

Jianhua Zhang
Department of Medical Oncology
Dana-Farber Cancer Institute
44 Binney Street
Boston, MA 02115-6084