Learn R Programming

redshift (version 0.5)

redshift.tables: List available Tables

Description

Lists the names of the tables available in the Redshift database

Usage

redshift.tables(conn, schema='public')

Arguments

conn
RJDBC connection created with redshift.connect
schema
The schema name

Value

Data frame containing the names of the tables.

See Also

redshift.connect

Examples

Run this code
require(redshift)
# conn <- redshift.connect("jdbc:postgresql://blah.blah.eu-west-1.redshift.amazonaws.com:5439/data", "username", "password")
# tables <- redshift.tables(conn)
# tables2 <- redshift.tables(conn, schema='test')

Run the code above in your browser using DataLab