Query FWA PostgreSQL Database — frs_db_query • fresh

Executes a SQL query on an open connection. Uses sf::st_read() so spatial columns are returned as sf geometry.

Usage

frs_db_query(conn, query)

Arguments

conn: A DBI::DBIConnection object (from frs_db_conn()).
query: Character. SQL query string.

Value

An sf data frame (if the query returns geometry) or a plain data frame.

See also

Other database: frs_db_conn()

Examples

if (FALSE) { # \dontrun{
conn <- frs_db_conn()
frs_db_query(conn, "SELECT * FROM whse_basemapping.fwa_lakes_poly LIMIT 5")
DBI::dbDisconnect(conn)
} # }