fetch_table: Query Table

In cjcallag/ps50sr: Public Safety 50 State Report

Description

Query Table

Usage

fetch_table(conn, table, where = "", dt = TRUE, verbose = TRUE)

Arguments

conn	connection to a database.
table	a character vector naming the table to query (e.g., "arrests")
where	a character vector for valid SQL WHERE query (e.g., "State = 'California' AND Variable = '2007'")
dt	a logical, if true table will be coerced to data.table
verbose	a logical, if true the function prints the SQL query

Examples

## Not run: fetch_arrests(conn = con, table = "arrests", where = "State = 'California' AND Variable = '2007'")

cjcallag/ps50sr documentation built on Dec. 19, 2021, 5:11 p.m.