importPostgreSQLTable: importPostgreSQLTable

Description Usage Arguments Examples

View source: R/importPostgreSQLTable.R

Description

Function to import all specified tables from a postgreSQL database

Usage

1
2
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

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

gwielinski/GWmisc documentation built on May 14, 2017, 6:06 p.m.