dbplyr: pull.tbl_sql – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

pull.tbl_sql

Extract a single column

This is a method for the dplyr pull() generic. It evaluates the query retrieving just the specified column.

## S3 method for class 'tbl_sql'
pull(.data, var = -1)

.data

A lazy data frame backed by a database query.

var

A variable specified as:

The default returns the last column (on the assumption that's the column you've created most recently).

This argument is taken by expression and supports quasiquotation (you can unquote column names and column locations).

A vector of data.

library(dplyr, warn.conflicts = FALSE)

db <- memdb_frame(x = 1:5, y = 5:1)
db %>%
  mutate(z = x + y * 2) %>%
  pull()

A 'dplyr' Back End for Databases

v2.1.1

MIT + file LICENSE

Authors

Hadley Wickham [aut, cre], Maximilian Girlich [aut], Edgar Ruiz [aut], RStudio [cph, fnd]

Initial release