Check and create schema. — dbSchema • rpostgis

Checks the existence, and if necessary, creates a schema.

Usage

dbSchema(conn, name, display = TRUE, exec = TRUE)

Arguments

conn: A connection object (required, even if exec = FALSE).
name: A character string specifying a PostgreSQL schema name.
display: Logical. Whether to display the query (defaults to TRUE).
exec: Logical. Whether to execute the query (defaults to TRUE). Note: if exec = FALSE, the function still checks the existence of the schema, but does not create it if it does not exists.

Value

If exec = TRUE, returns (invisible) TRUE if the schema exists (whether it was already available or was just created).

See also

The PostgreSQL documentation: http://www.postgresql.org/docs/current/static/sql-createschema.html

Author

Mathieu Basille mathieu@basille.org

Examples

if (FALSE) { # \dontrun{
    dbSchema(conn, name = "schema", exec = FALSE)
} # }