| 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.