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]