importPostgreSQLTable: importPostgreSQLTable

In gwielinski/GWmisc: Provides various useful functions in R

Description

Function to import all specified tables from a postgreSQL database

Usage

importPostgreSQLTable(dbname, host, port, user, password, tablename, rowProp,
  random, where = NULL, objectNames = NULL)

Arguments

dbname	parameter specific to the connection to the db
host	parameter specific to the connection to the db
port	parameter specific to the connection to the db
user	parameter specific to the connection to the db
password	parameter specific to the connection to the db
tablename	character vector containing names of the desired tables to be imported
rowProp	numeric vector containing the proportion of rows to be imported (from 0 to 1)
random	logical vector stating if the select query should be done in a random or sequential manner (TRUE is set to random)
where	character vector to parse as a where clause inside the query
objectNames	character vector to assign a name to the object that will be parsed to the global environment

Examples

importPostgreSQLTable("db", "localhost", 5431, "postgres", "pass", c("table1", "table2"), c(0.5, 1), c(TRUE, FALSE))

gwielinski/GWmisc documentation built on May 17, 2019, 9:31 a.m.