createEXTENSION: Generate a PostgreSQL CREATE EXTENSION statement, optionally execute the statement if con is not NULL.
Description
Generate a PostgreSQL CREATE EXTENSION statement, optionally execute the statement if con is not NULL.
Usage
createEXTENSION(
name,
if_not_exists = FALSE,
schema = NULL,
version = NULL,
cascade = FALSE,
con = NULL
)
Value
A string, PostgreSQL CREATE EXTENSION statement; or the results retrieved by DBI::dbSendQuery after executing the statement.
Arguments
- name
A string, the "extension_name" parameter for PostgreSQL CREATE EXTENSION.
- if_not_exists
TRUE/FALSE, if TRUE, adds "IF NOT EXISTS" to PostgreSQL CREATE EXTENSION statement.
- schema
A string, the "schema_name" parameter for PostgreSQL CREATE EXTENSION.
- version
A string, the "version" parameter for PostgreSQL CREATE EXTENSION.
- cascade
TRUE/FALSE, if TRUE, adds "CASCADE" to PostgreSQL CREATE EXTENSION statement.
- con
A database connection that can be passed to DBI::dbSendQuery/DBI::dbGetQuery.