Convert row names back and forth between columns
These functions provide a reasonably automatic way of preserving the row names of data frame during back-and-forth translation to an SQL table. By default, row names will be converted to an explicit column called "row_names", and any query returning a column called "row_names" will have those automatically set as row names. These methods are mostly useful for backend implementers.
sqlRownamesToColumn(df, row.names = NA) sqlColumnToRownames(df, row.names = NA)
df |
A data frame |
row.names |
Either If A string is equivalent to For backward compatibility, |
# If have row names sqlRownamesToColumn(head(mtcars)) sqlRownamesToColumn(head(mtcars), FALSE) sqlRownamesToColumn(head(mtcars), "ROWNAMES") # If don't have sqlRownamesToColumn(head(iris)) sqlRownamesToColumn(head(iris), TRUE) sqlRownamesToColumn(head(iris), "ROWNAMES")
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.