[R] help in dbWriteTable

Andreas Borg andreas.borg at unimedizin-mainz.de
Fri Dec 2 09:53:10 CET 2011


you can fetch the column names of a table with dbListFields and then 
reorder or rename the data frame according to those.

If you want more specific help, provide an example (RSQLite would be a 
good choice as database engine to make it easily reproducible for others).

Best regards,


arunkumar1111 schrieb:
> hi 
>  I need some help in dbWriteTable. 
> I'm not able to insert the rows in the table if the column order are not
> same in the database and in the dataframe which i'm inserting. Also facing
> issue if the table is already created externally and inserting it thru
> dbWrite.
> is there some way that we can sepecify the rownames in the dbwrite..or any
> method which will solve my problem
> --
> View this message in context: http://r.789695.n4.nabble.com/help-in-dbWriteTable-tp4145110p4145110.html
> Sent from the R help mailing list archive at Nabble.com.
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

Andreas Borg
Abteilung Medizinische Informatik

Universitätsmedizin der Johannes Gutenberg-Universität Mainz
Institut für Med. Biometrie, Epidemiologie und Informatik (IMBEI)
Obere Zahlbacher Straße 69, 55131 Mainz

Tel:  +49 (0) 6131 17-5062

E-Mail: andreas.borg at uni-mainz.de

More information about the R-help mailing list