Provides functions for connecting to, reading from and writing to a PostgreSQL database. Facilities for tracing the communication between R and PostgreSQL are provided, as are function to retieve detailed session metadata.
Package: | rpg |
Type: | Package |
Version: | 1.5 |
Date: | 2017-2-8 |
License: | GPL |
The main functions are connect
, which establishes a connection,
query
, which issues queries and fetch
, which retieves results.
Intelligent defaults are used throughout. Functions that require a connection
will automatically attempt to establish a valid connection based on a previous
connection or from defaults. The defaults can be overriden in a variety of
ways.