ranges_sql {OpenRange}R Documentation

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.


[Package OpenRange version 0.0.1 Index]