get_table: Get specified table from OxCOVID19 Database

Description Usage Arguments Value Author(s) Examples

View source: R/get_table.R

Description

Get specified table from OxCOVID19 Database

Usage

1
2
3
get_table(con, tbl_name)

get_tables(con, tbl_names)

Arguments

con

Connection to OxCOVID19 Database. This can be specified using the connect_oxcovid19() function.

tbl_name

Name of table available in OxCOVID19 Database. Should be one of the table names given by a call to list_tables().

tbl_names

Name of tables available in OxCOVID19 Database. Should be a character vector of names of tables found in the table names given by a call to list_tables().

Value

For get_table(), an RPostgres_tbl object of the specified OxCOVID19 Database table. For get_tables(), an RPostgres_tbl object containing a named list of the specified OxCOVID19 Database tables.

Author(s)

Ernest Guevarra

Examples

1
2
3
4
5
6
7
8
## Create a connection to OxCOVID19 Database
con <- connect_oxcovid19()

## Get epidemiology table
get_table(con = con, tbl_name = "epidemiology")

## Get epidemiology and weather tables
get_tables(con = con, tbl_names = c("epidemiology", "weather"))

oxcovid19 documentation built on Jan. 13, 2021, 8:50 p.m.