R Interface to the 'PostgreSQL' Database System
![[R logo]](../../../doc/html/Rlogo.svg)
![[Up]](../../../doc/html/left.jpg)
![[Top]](../../../doc/html/up.jpg)
Documentation for package ‘RPostgreSQL’ version 0.7-6
Help Pages
-- 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 |