# R Interface to the 'PostgreSQL' Database System

## Documentation for package ‘RPostgreSQL’ version 0.7-8

- DESCRIPTION file.
- Package NEWS.

## Help Pages

C D F I M P S misc

## -- C --

coerce-method | Summarize an PostgreSQL object
coerce-methods | Summarize an PostgreSQL object

## -- D --

dbApply | Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbApply-method | Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbApply-methods | Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbBegin-method | DBMS Transaction Management
dbCallProc-method | Call an SQL stored procedure
dbCallProc-methods | Call an SQL stored procedure
dbClearResult-method | Execute a statement on a given database connection
dbClearResult-methods | Execute a statement on a given database connection
dbColumnInfo-method | Database interface meta-data
dbColumnInfo-methods | Database interface meta-data
dbCommit-method | DBMS Transaction Management
dbConnect-method | Create a connection object to an PostgreSQL DBMS
dbConnect-methods | Create a connection object to an PostgreSQL DBMS
dbDataType-method | Determine the SQL Data Type of an S object
dbDataType-methods | Determine the SQL Data Type of an S object
dbDisconnect-method | Create a connection object to an PostgreSQL DBMS
dbDisconnect-methods | Create a connection object to an PostgreSQL DBMS
dbDriver-method | PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbDriver-methods | PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbExistsTable-method | Convenience functions for Importing/Exporting DBMS tables
dbExistsTable-methods | Convenience functions for Importing/Exporting DBMS tables
dbGetDBIVersion-methods | Database interface meta-data
dbGetException-method | Execute a statement on a given database connection
dbGetException-methods | Execute a statement on a given database connection
dbGetInfo | Database interface meta-data
dbGetInfo-method | Database interface meta-data
dbGetQuery-method | Execute a statement on a given database connection
dbGetQuery-methods | Execute a statement on a given database connection
dbGetRowCount-method | Database interface meta-data
dbGetRowCount-methods | Database interface meta-data
dbGetRowsAffected-method | Database interface meta-data
dbGetRowsAffected-methods | Database interface meta-data
dbGetStatement-method | Database interface meta-data
dbGetStatement-methods | Database interface meta-data
dbHasCompleted-method | Database interface meta-data
dbHasCompleted-methods | Database interface meta-data
dbListConnections-method | List items from an PostgreSQL DBMS and from objects
dbListConnections-methods | List items from an PostgreSQL DBMS and from objects
dbListFields-method | List items from an PostgreSQL DBMS and from objects
dbListFields-methods | List items from an PostgreSQL DBMS and from objects
dbListResults-method | List items from an PostgreSQL DBMS and from objects
dbListResults-methods | List items from an PostgreSQL DBMS and from objects
dbListTables-method | List items from an PostgreSQL DBMS and from objects
dbListTables-methods | List items from an PostgreSQL DBMS and from objects
dbObjectId-class | Class dbObjectId
dbReadTable-method | Convenience functions for Importing/Exporting DBMS tables
dbReadTable-methods | Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-method | Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-methods | Convenience functions for Importing/Exporting DBMS tables
dbRollback-method | DBMS Transaction Management
dbSendQuery-method | Execute a statement on a given database connection
dbSendQuery-methods | Execute a statement on a given database connection
dbSetDataMappings-method | Set data mappings between PostgreSQL and R/S-Plus
dbSetDataMappings-methods | Set data mappings between PostgreSQL and R/S-Plus
dbUnloadDriver-method | PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbUnloadDriver-methods | PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbWriteTable-method | Convenience functions for Importing/Exporting DBMS tables
dbWriteTable-methods | Convenience functions for Importing/Exporting DBMS tables

## -- F --

fetch-method | Fetch records from a previously executed query
fetch-methods | Fetch records from a previously executed query
format-method | Summarize an PostgreSQL object
format-methods | Summarize an PostgreSQL object

## -- I --

isPostgresqlIdCurrent | Check whether a database handle object is valid or not
isSQLKeyword-method | Make R/S-Plus identifiers into quoted PostgreSQL identifiers
isSQLKeyword-methods | Make R/S-Plus identifiers into quoted PostgreSQL identifiers

## -- M --

make.db.names-method | Make R/S-Plus identifiers into quoted PostgreSQL identifiers

## -- P --

PostgreSQL | Instantiate a PostgreSQL client from the current R or S-Plus session
postgresqlBuildTableDefinition | Build the SQL CREATE TABLE definition as a string
postgresqlCloneConnection | Support Functions
postgresqlCloseConnection | Support Functions
postgresqlCloseDriver | Support Functions
postgresqlCloseResult | Support Functions
PostgreSQLConnection-class | Class PostgreSQLConnection
PostgreSQLConnection-method | DBMS Transaction Management
postgresqlConnectionInfo | Support Functions
postgresqlCopyIn | Support Functions
postgresqlCopyInDataframe | Support Functions
postgresqlDataType | Support Functions
postgresqlDBApply | Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
postgresqlDescribeConnection | Support Functions
postgresqlDescribeDriver | Support Functions
postgresqlDescribeFields | Support Functions
postgresqlDescribeResult | Support Functions
PostgreSQLDriver-class | Class PostgreSQLDriver
postgresqlDriverInfo | Support Functions
postgresqlEscapeBytea | Support Functions
postgresqlEscapeStrings | Support Functions
postgresqlExecStatement | Support Functions
postgresqlFetch | Support Functions
postgresqlgetResult | Support Functions
postgresqlImportFile | Support Functions
postgresqlInitDriver | Support Functions
postgresqlNewConnection | Support Functions
PostgreSQLObject-class | Class PostgreSQLObject
postgresqlpqExec | Support Functions
postgresqlQuickSQL | Support Functions
postgresqlQuoteId | Support Functions
postgresqlReadTable | Support Functions
PostgreSQLResult-class | Class PostgreSQLResult
postgresqlResultInfo | Support Functions
postgresqlTableRef | Support Functions
postgresqlTransactionStatement | Support Functions
postgresqlUnescapeBytea | Support Functions
postgresqlWriteTable | Support Functions
print-method | Summarize an PostgreSQL object

## -- S --

show-method | Summarize an PostgreSQL object
show-methods | Summarize an PostgreSQL object
SQLKeywords-method | Make R/S-Plus identifiers into quoted PostgreSQL identifiers
SQLKeywords-methods | Make R/S-Plus identifiers into quoted PostgreSQL identifiers
summary-method | Summarize an PostgreSQL object
summary-methods | Summarize an PostgreSQL object

## -- misc --

.conflicts.OK | Support Functions
.PostgreSQL.NA.string | Support Functions
.PostgreSQLPkgName | Support Functions
.PostgreSQLPkgRCS | Support Functions
.PostgreSQLPkgVersion | Support Functions
.PostgreSQLSQLKeywords | Support Functions