[R] help in dbWriteTable

[Andreas Borg]

Hello,

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,

Andreas

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