alterDATABASE | Generate a PostgreSQL ALTER DATABASE statement, optionally... |
alterSCHEMA | Generate a PostgreSQL ALTER SCHEMA statement, optionally... |
alterTABLE | Generate a PostgreSQL ALTER TABLE statement, optionally... |
arrayStrToVec | Write a PostgreSQL array as a string from a vector. |
callFUNCTION | Generate a PostgreSQL statement to execute a function,... |
callPROCEDURE | Generate a PostgreSQL statement to execute a procedure,... |
connect | Connect to a local database with local credentials using... |
COPY | Generate a PostgreSQL COPY command, optionally execute the... |
createDATABASE | Generate a PostgreSQL CREATE DATABASE statement, optionally... |
createEXTENSION | Generate a PostgreSQL CREATE EXTENSION statement, optionally... |
createFUNCTION | Generate a PostgreSQL CREATE FUNCTION statement, optionally... |
createPROCEDURE | Generate a PostgreSQL CREATE PROCEDURE statement, optionally... |
createSCHEMA | Generate a PostgreSQL CREATE SCHEMA statement, optionally... |
create_sql_script | Create a SQL script, optionally execute the statement if con... |
createTABLE | Generate a PostgreSQL CREATE TABLE statement, optionally... |
createTRIGGER | Generate a PostgreSQL CREATE TRIGGER statement, optionally... |
DELETE | Generate a PostgreSQL DELETE statement, optionally execute... |
dropDATABASE | Generate a PostgreSQL DROP DATABASE statement, optionally... |
dropEXTENSION | Generate a PostgreSQL DROP EXTENSION statement, optionally... |
dropFUNCTION | Generate a PostgreSQL DROP FUNCTION statement, optionally... |
dropPROCEDURE | Generate a PostgreSQL DROP PROCEDURE statement, optionally... |
dropSCHEMA | Generate a PostgreSQL DROP SCHEMA statement, optionally... |
dropTABLE | Generate a PostgreSQL DROP TABLE statement, optionally... |
dropTRIGGER | Generate a PostgreSQL DROP TRIGGER statement, optionally... |
INSERT | Generate a PostgreSQL INSERT statement, optionally execute... |
insert_batch_chunker | Helper function for INSERT |
insert_table_chunker | Helper function for INSERT |
pg_addColumn | Helper command to add a column via ALTER TABLE. |
pg_alterColumnType | Helper command to alter a column's data type via ALTER TABLE. |
pg_data_types | PostgreSQL data types |
pg_dropColumn | Helper command to drop a column via ALTER TABLE. |
pg_renameColumn | Helper command to rename a column via ALTER TABLE. |
pg_renameTable | Helper command to rename a table via ALTER TABLE. |
querySELECT | Generate a PostgreSQL select statement, optionally execute... |
quoteText2 | Add single quotes to strings using stringi::stri_join, useful... |
sql_80_char_comment | Add a 80 char SQL comment, intended to be used for visual... |
sql_comment | Add a single line SQL comment. |
sqlNameWalk | Convert a column name into a PostgreSQL compatible name. |
sqlTypeWalk | Get the PostgreSQL data type for a given R data type. |
TRUNCATE | Generate a PostgreSQL TRUNCATE statement, optionally execute... |
UPDATE | Generate a PostgreSQL UPDATE statement, optionally execute... |
vecToArrayStr | Write a PostgreSQL array as a string using ARRAY[] format... |
vecToArrayStr2 | Write a PostgreSQL array as a string using format from a... |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.