alterSCHEMA

Generate a PostgreSQL ALTER 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

alterSCHEMA function

<dl><dt>name</dt>
<dd>A string, the "name" parameter for PostgreSQL ALTER SCHEMA.</dd>
<dt>rename_to</dt>
<dd>A string, the "new_name" parameter for PostgreSQL ALTER SCHEMA.</dd>
<dt>owner_to</dt>
<dd>A string, the "new_owner" parameter for PostgreSQL ALTER SCHEMA.</dd>
<dt>con</dt>
<dd>A database connection that can be passed to DBI::dbSendQuery/DBI::dbGetQuery.</dd></dl>

Arguments

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

<dl>

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


<dt>rename_to</dt>
<dd>A string, the "new_name" parameter for PostgreSQL ALTER SCHEMA.</dd>


<dt>owner_to</dt>
<dd>A string, the "new_owner" parameter for PostgreSQL ALTER SCHEMA.</dd>


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

</dl>

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

Description

Usage

Value

Arguments

Examples