Package: pgTools 1.0.1
pgTools: Functions for Generating PostgreSQL Statements/Scripts
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>.
Authors:
pgTools_1.0.1.tar.gz
pgTools_1.0.1.zip(r-4.5)pgTools_1.0.1.zip(r-4.4)pgTools_1.0.1.zip(r-4.3)
pgTools_1.0.1.tgz(r-4.4-any)pgTools_1.0.1.tgz(r-4.3-any)
pgTools_1.0.1.tar.gz(r-4.5-noble)pgTools_1.0.1.tar.gz(r-4.4-noble)
pgTools_1.0.1.tgz(r-4.4-emscripten)pgTools_1.0.1.tgz(r-4.3-emscripten)
pgTools.pdf |pgTools.html✨
pgTools/json (API)
# Install 'pgTools' in R: |
install.packages('pgTools', repos = c('https://tconwell.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/tconwell/pgtools/issues
Last updated 2 years agofrom:ab45ad3713. Checks:OK: 7. Indexed: yes.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Nov 17 2024 |
R-4.5-win | OK | Nov 17 2024 |
R-4.5-linux | OK | Nov 17 2024 |
R-4.4-win | OK | Nov 17 2024 |
R-4.4-mac | OK | Nov 17 2024 |
R-4.3-win | OK | Nov 17 2024 |
R-4.3-mac | OK | Nov 17 2024 |
Exports:alterDATABASEalterSCHEMAalterTABLEarrayStrToVeccallFUNCTIONcallPROCEDUREconnectCOPYcreate_sql_scriptcreateDATABASEcreateEXTENSIONcreateFUNCTIONcreatePROCEDUREcreateSCHEMAcreateTABLEcreateTRIGGERDELETEdropDATABASEdropEXTENSIONdropFUNCTIONdropPROCEDUREdropSCHEMAdropTABLEdropTRIGGERINSERTinsert_batch_chunkerinsert_table_chunkerpg_addColumnpg_alterColumnTypepg_data_typespg_dropColumnpg_renameColumnpg_renameTablequerySELECTquoteText2sql_80_char_commentsql_commentsqlNameWalksqlTypeWalkTRUNCATEUPDATEvecToArrayStrvecToArrayStr2
Dependencies:bitbit64blobclidata.tableDBIgluehmslifecycleodbcpkgconfigRcpprlangstringitoolboxvctrs