pg.copy: A lightweight wrapper around postgresqlCopyInDataframe that...
In adjust/rport: Connection management and SQL parallelisation for R analytics on big database clusters.
Description
A lightweight wrapper around postgresqlCopyInDataframe that allows for
custom field lists and temporary tables. It only allows numeric, character,
integer, date/time and bool types. It's more useful than dbWriteTable because
it allows SQL-copying into tables that have fields other than the data.frame.
Also using pg.copy you can SQL-copy in transactions with temp tables.
Usage
1
pg.copy(con, tbl.name, DT)
Arguments
con
PostgreSQLConnection
tbl.name
character
tbl.name
PostgreSQLConnection
adjust/rport documentation built on May 10, 2019, 5:55 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description
A lightweight wrapper around postgresqlCopyInDataframe that allows for custom field lists and temporary tables. It only allows numeric, character, integer, date/time and bool types. It's more useful than dbWriteTable because it allows SQL-copying into tables that have fields other than the data.frame. Also using pg.copy you can SQL-copy in transactions with temp tables.
Usage
1 | pg.copy(con, tbl.name, DT)
|
Arguments
con |
PostgreSQLConnection |
tbl.name |
character |
tbl.name |
PostgreSQLConnection |
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.