redshift (version 0.5)

redshift.submitquery: Executes a DBML query

Description

Submits a DBML query to the database.

Usage

redshift.submitquery(conn, ...)

Arguments

conn

The database connection

...

Strings representing the query. These will be concatenated together with paste to make it easier to write multi-line queries. Allows sending DBML like queries- requiring no response from the DB.

Value

NA

Examples

require(redshift)
# conn <- redshift.connect("jdbc:postgresql://blah.blah.eu-west-1.redshift.amazonaws.com:5439/data", "username", "password")
#results <- redshift.query(conn, "INSERT INTO mytable",
#                                "VALUES (2,652,'Eeshan','Chatterjee')")