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@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.b...@uni-mainz.de
______________________________________________
R-help@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.
