dbCreateSchemaEM: Schema Creation

In AndreMikulec/econModel: Meaningful Social and Economic Data from ALFRED and elsewhere

Description

Create a schema in the database.

Usage

dbCreateSchemaEM(
  connName,
  schema,
  role_specification = schema,
  grant_all_roles = schema,
  env,
  display = TRUE,
  exec = TRUE
)

Arguments

connName	String. Default is "connEM". Contains the name of the variable that contains the name of the "connection" in the environment "env".
schema	String. Required. Potential schema in the database.
env	Environment. Default is the .Global environment. This is the environment to return the connection object "connEM".
display	Logical. Whether to display the query (defaults to TRUE).
exec	Logical. Whether to execute the query (defaults to TRUE).
role_specification.	String. The schema role specification. Defaults to "schema".
grant_all	vector of Strings. Roles to be GRANT ALLed to this schema. Defaults to "schema".

Value

TRUE(success) or Error(failure)

Examples

## Not run: 
# Does not check if the schema already exists
dbCreateSchemaEM(schema = "r_user")

# Later
dbCreateSchemaEM(schema = "r_user_2", role_specification = "r_user", grant_all_roles = "r_user")


## End(Not run)

AndreMikulec/econModel documentation built on June 30, 2021, 9:48 a.m.