Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

Id

Refer to a table nested in a hierarchy (e.g. within a schema)


Description

Objects of class Id have a single slot name, which is a named character vector. The dbQuoteIdentifier() method converts Id objects to strings. Support for Id objects depends on the database backend. They can be used in the following methods as name argument:

Usage

Id(...)

Arguments

...

Components of the hierarchy, e.g. schema, table, or cluster, catalog, schema, table. For more on these concepts, see https://stackoverflow.com/questions/7022755/

Examples

Id(schema = "dbo", table = "Customer")
dbQuoteIdentifier(ANSI(), Id(schema = "nycflights13", table = "flights"))
Id(cluster = "mycluster", catalog = "mycatalog", schema = "myschema", table = "mytable")

DBI

R Database Interface

v1.1.1
LGPL (>= 2.1)
Authors
R Special Interest Group on Databases (R-SIG-DB) [aut], Hadley Wickham [aut], Kirill Müller [aut, cre] (<https://orcid.org/0000-0002-1416-3412>), R Consortium [fnd]
Initial release
2021-01-04

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.