Functions for Generating PostgreSQL Statements/Scripts
Generate a PostgreSQL ALTER DATABASE statement, optionally execute the...
Generate a PostgreSQL ALTER SCHEMA statement, optionally execute the s...
Generate a PostgreSQL ALTER TABLE statement, optionally execute the st...
Write a PostgreSQL array as a string from a vector.
Generate a PostgreSQL statement to execute a function, optionally exec...
Generate a PostgreSQL statement to execute a procedure, optionally exe...
Connect to a local database with local credentials using DBI/odbc.
Generate a PostgreSQL COPY command, optionally execute the statement i...
Create a SQL script, optionally execute the statement if con is not NU...
Generate a PostgreSQL CREATE DATABASE statement, optionally execute th...
Generate a PostgreSQL CREATE EXTENSION statement, optionally execute t...
Generate a PostgreSQL CREATE FUNCTION statement, optionally execute th...
Generate a PostgreSQL CREATE PROCEDURE statement, optionally execute t...
Generate a PostgreSQL CREATE SCHEMA statement, optionally execute the ...
Generate a PostgreSQL CREATE TABLE statement, optionally execute the s...
Generate a PostgreSQL CREATE TRIGGER statement, optionally execute the...
Generate a PostgreSQL DELETE statement, optionally execute the stateme...
Generate a PostgreSQL DROP DATABASE statement, optionally execute the ...
Generate a PostgreSQL DROP EXTENSION statement, optionally execute the...
Generate a PostgreSQL DROP FUNCTION statement, optionally execute the ...
Generate a PostgreSQL DROP PROCEDURE statement, optionally execute the...
Generate a PostgreSQL DROP SCHEMA statement, optionally execute the st...
Generate a PostgreSQL DROP TABLE statement, optionally execute the sta...
Generate a PostgreSQL DROP TRIGGER statement, optionally execute the s...
Generate a PostgreSQL INSERT statement, optionally execute the stateme...
Helper function for INSERT
Helper function for INSERT
Helper command to add a column via ALTER TABLE.
Helper command to alter a column's data type via ALTER TABLE.
PostgreSQL data types
Helper command to drop a column via ALTER TABLE.
Helper command to rename a column via ALTER TABLE.
Helper command to rename a table via ALTER TABLE.
Generate a PostgreSQL select statement, optionally execute the stateme...
Add single quotes to strings using stringi::stri_join, useful for conv...
Add a 80 char SQL comment, intended to be used for visual breaks in do...
Add a single line SQL comment.
Convert a column name into a PostgreSQL compatible name.
Get the PostgreSQL data type for a given R data type.
Generate a PostgreSQL TRUNCATE statement, optionally execute the state...
Generate a PostgreSQL UPDATE statement, optionally execute the stateme...
Write a PostgreSQL array as a string using ARRAY[] format from a vecto...
Write a PostgreSQL array as a string using format from a vector.
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>.