db_getColumn: gets specified columns from a table in the database, allows...

View source: R/dbAccess.R

db_getColumnR Documentation

gets specified columns from a table in the database, allows for where statements

Description

gets specified columns from a table in the database, allows for where statements

Usage

db_getColumn(db, tableName, column = NA, where = NA)

Arguments

db

database access 'handle'

tableName

name of the table

column

if NA then all columns are retrieved, otherwise should be a character vector specifying the names of the columns to be retrieved

where

allows for conditional retrieving, should be in the form of a character vector specifying the conditions and boolean operators, eg: c("age = 45", " AND ", "gender = 'M')

Value

data.frame


BenBruyneel/BBPersonalR documentation built on Aug. 23, 2024, 8:28 p.m.