runSQLinText: Runs the query given as sqlText string

In amit-agni/cutlery: Collection of helper functions

Description

Connects to postgresSQL database and runs the query given in the string. Possible enhancements : Store as RDS

Usage

runSQLinText(sqlText, username = NA, password = NA, dbname, host, port)

Arguments

sqlText	Sql query
password	database passowrd, if not provided will be prompted
dbname	database name
host	database host name
port	database port
user	database user name, if not provided will be prompted

Author(s)

Amit Agni

See Also

runSQLinFile

Other database functions: runSQLinFile()

Examples

runPostgreSQL_asText(sqlText = "select * from table limit 19",user = "",password="",readFromRds = F,dbname = "dw",host = "dwserver", port = 5050)

amit-agni/cutlery documentation built on Dec. 31, 2019, 2:09 p.m.