db-misc: Miscellaneous database generics

In dbplyr: A 'dplyr' Back End for Databases

Miscellaneous database generics

Description

• db_connection_describe() provides a short string describing the database connection, helping users tell which database a table comes from. It should be a single line, and ideally less than 60 characters wide.

Usage

db_connection_describe(con, ...)

sql_join_suffix(con, suffix, ...)

db_sql_render(con, sql, ..., cte = FALSE, sql_options = NULL)

db_col_types(con, table, call)

dbplyr_edition(con)

Details

• dbplyr_edition() declares which version of the dbplyr API you want. See below for more details.

• db_col_types() returns the column types of a table.

dbplyr 2.0.0

dbplyr 2.0.0 renamed a number of generics so that they could be cleanly moved from dplyr to dbplyr. If you have an existing backend, you'll need to rename the following methods.

• dplyr::db_desc() -> dbplyr::db_connection_describe() (also note that the argument named changed from x to con).

See Also

Other generic: db-sql, db_copy_to(), sql_escape_logical()

dbplyr documentation built on Oct. 26, 2023, 9:06 a.m.