redshift.columns: Columns in Redshift table

In pingles/redshift-r: Easier access to AWS Redshift clusters

Description

Provides metadata about the columns available within a Redshift table

Usage

redshift.columns(conn, schema='public', tableName)

Arguments

conn	The RJDBC connection object created with redshift.connect
schema	The schema name
tableName	Table name as a string

Value

Returns a dataframe listing: column name, data type, nullable.

Author(s)

Paul Ingles

Examples

require(redshift)
# conn <- redshift.connect("jdbc:postgresql://blah.blah.eu-west-1.redshift.amazonaws.com:5439/data", "username", "password")
# cols <- redshift.columns(conn, "weblog")
# cols2 <- redshift.columns(conn, "dev", weblog")

pingles/redshift-r documentation built on May 25, 2019, 7:13 a.m.