ranges_sql: Run an SQL query on the OpenRange database.

In OpenRange: Code to Access Open Access Species Range Maps

Run an SQL query on the OpenRange database.

Description

ranges_sql is an internal function used to submit SQL queries.

Usage

ranges_sql(
  query,
  user = "public_bien",
  password = "bien_public",
  ranges = NULL,
  limit = NULL,
  return.query = FALSE,
  schema = "analytical_db",
  db_name = "vegbien",
  print.query = FALSE
)

Arguments

query	A PostgreSQL query.
user	The username used to access the BIEN database
password	The password associated with the username
ranges	Alternative value to be substituted for "ranges" in queries when not NULL.
limit	A limit on the number of records to be returned. Should be a single number or NULL (the default).
return.query	Should the query used be returned rather than executed? Default is FALSE
schema	An alternative schema to be accessed. Used for testing purposes.
db_name	An alternate database to be used rather than the default, vegbien.
print.query	Should the query used be printed? Default is FALSE

Value

A dataframe returned by the query.

OpenRange documentation built on April 4, 2025, 2:08 a.m.