as.dbi.table

is.dbi.table

Test whether an object is a <code>dbi.table</code>, or coerce it if possible.

Query database tables over a 'DBI' connection using 'data.table' syntax.
Attach database schemas to the search path. Automatically merge using foreign
key constraints.

Kjell Konis

dbi.table

Database Queries Using 'data.table' Syntax

as.dbi.table function

<dl><dt>x</dt>
<dd>any R object.</dd>
<dt>conn</dt>
<dd>a connection handle returned by <code><a href="https://dbi.r-dbi.org/reference/dbConnect.html">dbConnect</a></code>.
Alternatively, <code>conn</code> may be a <code>dbi.table</code> or a
<code>dbi.catalog</code>; in these cases, the connection handle
is extracted from the provided object.</dd>
<dt>type</dt>
<dd>a character string. Possible choices are <code>"auto"</code>,
<code>"query"</code>, and <code>"temporary"</code>. See Details. The default
<code>"auto"</code> uses In Query tables when <code>x</code> has 500
or fewer rows or when creating a temporary table on the database
fails.</dd></dl>

Arguments

Coerce to DBI Table — as.dbi.table

<dl>

<dt>x</dt>
<dd>any R object.</dd>


<dt>conn</dt>
<dd>a connection handle returned by <code><a href='https://dbi.r-dbi.org/reference/dbConnect.html'>dbConnect</a></code>.
Alternatively, <code>conn</code> may be a <code>dbi.table</code> or a
<code>dbi.catalog</code>; in these cases, the connection handle
is extracted from the provided object.</dd>


<dt>type</dt>
<dd>a character string. Possible choices are <code>"auto"</code>,
<code>"query"</code>, and <code>"temporary"</code>. See Details. The default
<code>"auto"</code> uses In Query tables when <code>x</code> has 500
or fewer rows or when creating a temporary table on the database
fails.</dd>

</dl>

as.dbi.table: Coerce to DBI Table

Description

Usage

Value

Arguments

Details

Examples