createSCHEMA

Generate a PostgreSQL CREATE SCHEMA statement, optionally execute the statement if con is not NULL.

Create PostgreSQL statements/scripts from R, optionally executing the SQL statements.
Common SQL operations are included, although not every configurable option is available at this time.
SQL output is intended to be compliant with PostgreSQL syntax specifications. PostgreSQL documentation is available here
<https://www.postgresql.org/docs/current/index.html>.

Timothy Conwell

pgTools

Functions for Generating PostgreSQL Statements/Scripts

createSCHEMA function

<dl><dt>name</dt>
<dd>A string, the "schema_name" parameter for PostgreSQL CREATE SCHEMA.</dd>
<dt>authorization</dt>
<dd>A string, the "role_specification" parameter for PostgreSQL CREATE SCHEMA.</dd>
<dt>if_not_exists</dt>
<dd>TRUE/FALSE, if TRUE, adds "IF NOT EXISTS" to PostgreSQL CREATE SCHEMA statement.</dd>
<dt>con</dt>
<dd>A database connection that can be passed to DBI::dbSendQuery/DBI::dbGetQuery.</dd></dl>

Arguments

Generate a PostgreSQL CREATE SCHEMA statement, optionally execute the statement if con is not NULL. — createSCHEMA

<dl>

<dt>name</dt>
<dd>A string, the "schema_name" parameter for PostgreSQL CREATE SCHEMA.</dd>


<dt>authorization</dt>
<dd>A string, the "role_specification" parameter for PostgreSQL CREATE SCHEMA.</dd>


<dt>if_not_exists</dt>
<dd>TRUE/FALSE, if TRUE, adds "IF NOT EXISTS" to PostgreSQL CREATE SCHEMA statement.</dd>


<dt>con</dt>
<dd>A database connection that can be passed to DBI::dbSendQuery/DBI::dbGetQuery.</dd>

</dl>

Get 50% off unlimited learning

createSCHEMA: Generate a PostgreSQL CREATE SCHEMA statement, optionally execute the statement if con is not NULL.

Description

Usage

Value

Arguments

Examples