lares (version 5.4.1)

queryDB: PostgreSQL Queries on Database (Read)

Description

This function lets the user query a PostgreSQL database. Previously was called queryDummy but was replaced and deprecated for a more general function by using the from parameter.

Usage

queryDB(query, from, creds = NA)

Value

data.frame. Result of fetching the query data.

Arguments

query

Character. SQL Query

from

Character. Credential's user (see get_creds())

creds

Character. Credential's directory (see get_creds())

See Also

Other Credentials: db_download(), db_upload(), encrypt_file(), get_credentials(), get_tweets(), mail_send(), queryGA(), slackSend(), stocks_file()

Examples

if (FALSE) {
# Query a PostgreSQL database
query <- "SELECT * FROM my_table LIMIT 10"
result <- queryDB(query, from = "my_database")
head(result)
}