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

In DBI: R Database Interface

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:

• dbCreateTable()

• dbAppendTable()

• dbReadTable()

• dbWriteTable()

• dbExistsTable()

• dbRemoveTable() Objects of this class are also returned from dbListObjects().

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")

Example output

<Id> schema = dbo, table = Customer
<SQL> "nycflights13"."flights"
<Id> cluster = mycluster, catalog = mycatalog, schema = myschema, table = mytable

DBI documentation built on Jan. 15, 2021, 3:29 p.m.