connConnection-class

dbWriteTable,connConnection,ANY-method

dbSendQuery,connConnection-method

Implementations of pure virtual functions defined in the `DBI` package.

internal

Enables 'DBI' compliant packages to integrate with the 'RStudio' connections
pane, and the 'pins' package. It automates the display of schemata, tables, views, as well
as the preview of the table's top 1000 records.

Edgar Ruiz

connections

Integrates with the 'RStudio' Connections Pane and 'pins'

Posit Software, PBC 

DBI function

<dl><dt>conn</dt>
<dd>A DBIConnection object, as returned by
<code><a href="https://dbi.r-dbi.org/reference/dbConnect.html">dbConnect()</a></code>.</dd>
<dt>name</dt>
<dd>The table name, passed on to <code><a href="https://dbi.r-dbi.org/reference/dbQuoteIdentifier.html">dbQuoteIdentifier()</a></code>. Options are:<ul>
<li>a character string with the unquoted DBMS table name,
e.g. <code>"table_name"</code>,</li>
<li>a call to <code><a href="https://dbi.r-dbi.org/reference/Id.html">Id()</a></code> with components to the fully qualified table name,
e.g. <code>Id(schema = "my_schema", table = "table_name")</code></li>
<li>a call to <code><a href="https://dbi.r-dbi.org/reference/SQL.html">SQL()</a></code> with the quoted and fully qualified table name
given verbatim, e.g. <code>SQL('"my_schema"."table_name"')</code></li>
</ul></dd>
<dt>value</dt>
<dd>a <a href="/link/data.frame?package=connections&version=0.2.0" data-mini-rdoc="connections::data.frame">data.frame</a> (or coercible to data.frame).</dd>
<dt>...</dt>
<dd>Other parameters passed on to methods.</dd>
<dt>statement</dt>
<dd>a character string containing SQL.</dd></dl>

Arguments

DBI methods — DBI

<dl>

<dt>conn</dt>
<dd>A DBIConnection object, as returned by
<code><a href='https://dbi.r-dbi.org/reference/dbConnect.html'>dbConnect()</a></code>.</dd>


<dt>name</dt>
<dd>The table name, passed on to <code><a href='https://dbi.r-dbi.org/reference/dbQuoteIdentifier.html'>dbQuoteIdentifier()</a></code>. Options are:<ul>
<li>a character string with the unquoted DBMS table name,
e.g. <code>"table_name"</code>,</li>
<li>a call to <code><a href='https://dbi.r-dbi.org/reference/Id.html'>Id()</a></code> with components to the fully qualified table name,
e.g. <code>Id(schema = "my_schema", table = "table_name")</code></li>
<li>a call to <code><a href='https://dbi.r-dbi.org/reference/SQL.html'>SQL()</a></code> with the quoted and fully qualified table name
given verbatim, e.g. <code>SQL('"my_schema"."table_name"')</code></li>
</ul></dd>


<dt>value</dt>
<dd>a <a href='https://rdrr.io/r/base/data.frame.html'>data.frame</a> (or coercible to data.frame).</dd>


<dt>...</dt>
<dd>Other parameters passed on to methods.</dd>


<dt>statement</dt>
<dd>a character string containing SQL.</dd>

</dl>

DBI: DBI methods

Description

Usage

Arguments