Man pages for pgTools
Functions for Generating PostgreSQL Statements/Scripts

alterDATABASEGenerate a PostgreSQL ALTER DATABASE statement, optionally...
alterSCHEMAGenerate a PostgreSQL ALTER SCHEMA statement, optionally...
alterTABLEGenerate a PostgreSQL ALTER TABLE statement, optionally...
arrayStrToVecWrite a PostgreSQL array as a string from a vector.
callFUNCTIONGenerate a PostgreSQL statement to execute a function,...
callPROCEDUREGenerate a PostgreSQL statement to execute a procedure,...
connectConnect to a local database with local credentials using...
COPYGenerate a PostgreSQL COPY command, optionally execute the...
createDATABASEGenerate a PostgreSQL CREATE DATABASE statement, optionally...
createEXTENSIONGenerate a PostgreSQL CREATE EXTENSION statement, optionally...
createFUNCTIONGenerate a PostgreSQL CREATE FUNCTION statement, optionally...
createPROCEDUREGenerate a PostgreSQL CREATE PROCEDURE statement, optionally...
createSCHEMAGenerate a PostgreSQL CREATE SCHEMA statement, optionally...
create_sql_scriptCreate a SQL script, optionally execute the statement if con...
createTABLEGenerate a PostgreSQL CREATE TABLE statement, optionally...
createTRIGGERGenerate a PostgreSQL CREATE TRIGGER statement, optionally...
DELETEGenerate a PostgreSQL DELETE statement, optionally execute...
dropDATABASEGenerate a PostgreSQL DROP DATABASE statement, optionally...
dropEXTENSIONGenerate a PostgreSQL DROP EXTENSION statement, optionally...
dropFUNCTIONGenerate a PostgreSQL DROP FUNCTION statement, optionally...
dropPROCEDUREGenerate a PostgreSQL DROP PROCEDURE statement, optionally...
dropSCHEMAGenerate a PostgreSQL DROP SCHEMA statement, optionally...
dropTABLEGenerate a PostgreSQL DROP TABLE statement, optionally...
dropTRIGGERGenerate a PostgreSQL DROP TRIGGER statement, optionally...
INSERTGenerate a PostgreSQL INSERT statement, optionally execute...
insert_batch_chunkerHelper function for INSERT
insert_table_chunkerHelper function for INSERT
pg_addColumnHelper command to add a column via ALTER TABLE.
pg_alterColumnTypeHelper command to alter a column's data type via ALTER TABLE.
pg_data_typesPostgreSQL data types
pg_dropColumnHelper command to drop a column via ALTER TABLE.
pg_renameColumnHelper command to rename a column via ALTER TABLE.
pg_renameTableHelper command to rename a table via ALTER TABLE.
querySELECTGenerate a PostgreSQL select statement, optionally execute...
quoteText2Add single quotes to strings using stringi::stri_join, useful...
sql_80_char_commentAdd a 80 char SQL comment, intended to be used for visual...
sql_commentAdd a single line SQL comment.
sqlNameWalkConvert a column name into a PostgreSQL compatible name.
sqlTypeWalkGet the PostgreSQL data type for a given R data type.
TRUNCATEGenerate a PostgreSQL TRUNCATE statement, optionally execute...
UPDATEGenerate a PostgreSQL UPDATE statement, optionally execute...
vecToArrayStrWrite a PostgreSQL array as a string using ARRAY[] format...
vecToArrayStr2Write a PostgreSQL array as a string using format from a...
pgTools documentation built on March 31, 2023, 7:56 p.m.