Query a postgres database

Provides connection from fpr_db_conn as well as a subsequent disconnection

Usage

fpr_db_query(query = "SELECT * FROM bcfishpass.crossings limit 100;", ...)

Arguments

query

Quoted string query written in `sql`.

Value

Object pulled from database and message of how long the query took to complete.

See also

Other database postgres: fpr_db_conn(), fpr_dbq_lscols(), fpr_dbq_lstables(), fpr_dbq_subset()

Examples

if (FALSE) { # \dontrun{
fpr_db_query(query = fpr_dbq_subset())
} # }