pgTab: Read a full table from PostgreSQL database

Description Usage Arguments Details Examples

Description

Read a full table from PostgreSQL database

Usage

1
  pgTab(tab.name, con.drv = NULL)

Arguments

tab.name

a valid table

con.drv

a list containing a non-expired connection to and driver for PgSQL database

Details

Runs SQL query against and returns result

Examples

1
2
3
4
5
6
7
## Not run: 
## make a connection
c <- pgCon()  #running without argumetns requires pg.auth list set as global option
mytable.df<-pgQ("mytable", c)
pgDiscon(c)

## End(Not run)

ashander/use-PostgreSQL documentation built on May 12, 2019, 4:40 a.m.