Query database

Generic function to query database

db.query(query, con = NULL, params = NULL)

Arguments

query	SQL query string
con	database connection object
params	database connection information

Value

data frame with query results

Details

Given a connection and a query, will return a query as a data frame. Either con or params need to be specified. If both are specified it will use con.

Examples

# NOT RUN {
db.query('select count(id) from traits;', params=settings$database$bety)
# }