dbDriver-methods

dbUnloadDriver-methods

dbDriver,character-method

dbUnloadDriver,PostgreSQLDriver-method

PostgreSQL driver initialization and closing

methods

interface

database

Database interface and PostgreSQL driver for R This
package provides a Database Interface (DBI) compliant driver
for R to access PostgreSQL database systems.

In order to build and install this package from source, PostgreSQL
itself must be present your system to provide PostgreSQL
functionality via its libraries and header files. These files
are provided as postgresql-devel package under some Linux
distributions.

On Microsoft Windows system the attached libpq library source will be
used.

A wiki and issue tracking system for the package are available at
Google Code at https://code.google.com/p/rpostgresql/ .

Tomoaki Nishiyama

RPostgreSQL

R interface to the PostgreSQL database system

dbDriver-methods function

<dl class="dl-horizontal">
<dt>drvName</dt><dd>character name of the driver to instantiate.</dd>
<dt>drv</dt><dd>an object that inherits from <code>PostgreSQLDriver</code> as created by
 <code>dbDriver</code>.</dd>
<dt>max.con</dt><dd>optional integer requesting the maximum number of
simultanous connections (may be up to 100)</dd>.
<dt>fetch.default.rec</dt><dd>default number of records to retrieve per fetch.
Default is 500. This may be overridden in calls to <code><a rd-options="DBI" href="/link/fetch?package=RPostgreSQL&version=0.4-1&to=DBI" data-mini-rdoc="DBI::fetch">fetch</a></code>
with the <code>n=</code> argument.</dd>
<dt>force.reload</dt><dd>optional logical used to force re-loading or recomputing
the size of the connection table. Default is <code>FALSE</code>.</dd>
<dt>...</dt><dd>currently unused.</dd>
</dl>

Methods

PostgreSQL implementation of the Database Interface (DBI) classes
  and drivers — dbDriver-methods

<dl class='dl-horizontal'>
<dt>drvName</dt><dd>character name of the driver to instantiate.</dd>
<dt>drv</dt><dd>an object that inherits from <code>PostgreSQLDriver</code> as created by
 <code>dbDriver</code>.</dd>
<dt>max.con</dt><dd>optional integer requesting the maximum number of
simultanous connections (may be up to 100)</dd>.
<dt>fetch.default.rec</dt><dd>default number of records to retrieve per fetch.
Default is 500. This may be overridden in calls to <code><a rd-options='DBI' href='fetch'>fetch</a></code>
with the <code>n=</code> argument.</dd>
<dt>force.reload</dt><dd>optional logical used to force re-loading or recomputing
the size of the connection table. Default is <code>FALSE</code>.</dd>
<dt>...</dt><dd>currently unused.</dd>
</dl>

dbDriver-methods: PostgreSQL implementation of the Database Interface (DBI) classes and drivers

Description

Arguments

Methods

References

See Also

Examples