Package index

All functions

PostgreSQL()

Instantiate a PostgreSQL client from the current R or S-Plus session

PostgreSQLConnection-class

Class PostgreSQLConnection

PostgreSQLDriver-class

Class PostgreSQLDriver

PostgreSQLObject-class

Class PostgreSQLObject

PostgreSQLResult-class

Class PostgreSQLResult

dbApply-methods dbApply,PostgreSQLResult-method

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)

dbApply

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)

dbCallProc-methods dbCallProc,PostgreSQLConnection-method

Call an SQL stored procedure

dbBegin-method dbCommit-method dbRollback-method PostgreSQLConnection-method dbBegin,PostgreSQLConnection-method dbCommit,PostgreSQLConnection-method dbRollback,PostgreSQLConnection-method

DBMS Transaction Management

dbDisconnect-methods dbConnect-methods dbDisconnect,PostgreSQLConnection-method dbConnect,PostgreSQLDriver-method dbConnect,PostgreSQLConnection-method dbConnect,character-method

Create a connection object to an PostgreSQL DBMS

dbDataType-methods dbDataType,PostgreSQLObject-method

Determine the SQL Data Type of an S object

dbDriver-methods dbUnloadDriver-methods dbDriver,character-method dbUnloadDriver,PostgreSQLDriver-method

PostgreSQL implementation of the Database Interface (DBI) classes and drivers

dbGetInfo dbGetDBIVersion-methods dbGetStatement-methods dbGetRowCount-methods dbGetRowsAffected-methods dbColumnInfo-methods dbHasCompleted-methods dbGetInfo,PostgreSQLObject-method dbGetInfo,PostgreSQLDriver-method dbGetInfo,PostgreSQLConnection-method dbGetInfo,PostgreSQLResult-method dbGetStatement,PostgreSQLResult-method dbGetRowCount,PostgreSQLResult-method dbGetRowsAffected,PostgreSQLResult-method dbColumnInfo,PostgreSQLResult-method dbHasCompleted,PostgreSQLResult-method

Database interface meta-data

dbListTables-methods dbListFields-methods dbListConnections-methods dbListResults-methods dbListTables,PostgreSQLConnection-method dbListFields,PostgreSQLConnection,character-method dbListFields,PostgreSQLResult,missing-method dbListConnections,PostgreSQLDriver-method dbListResults,PostgreSQLConnection-method

List items from an PostgreSQL DBMS and from objects

dbObjectId-class

Class dbObjectId

dbReadTable-methods dbWriteTable-methods dbExistsTable-methods dbRemoveTable-methods dbReadTable,PostgreSQLConnection,character-method dbWriteTable,PostgreSQLConnection,character,character-method dbWriteTable,PostgreSQLConnection,character,data.frame-method dbExistsTable,PostgreSQLConnection,character-method dbRemoveTable,PostgreSQLConnection,character-method

Convenience functions for Importing/Exporting DBMS tables

dbSendQuery-methods dbGetQuery-methods dbClearResult-methods dbGetException-methods dbSendQuery,PostgreSQLConnection,character-method dbGetQuery,PostgreSQLConnection,character-method dbClearResult,PostgreSQLResult-method dbGetException,PostgreSQLConnection-method dbGetException,PostgreSQLResult-method

Execute a statement on a given database connection

dbSetDataMappings-methods dbSetDataMappings,PostgreSQLResult,data.frame-method

Set data mappings between PostgreSQL and R/S-Plus

fetch-methods fetch,PostgreSQLResult,numeric-method fetch,PostgreSQLResult,missing-method

Fetch records from a previously executed query

isPostgresqlIdCurrent()

Check whether a database handle object is valid or not

SQLKeywords-methods isSQLKeyword-methods make.db.names,PostgreSQLObject,character-method SQLKeywords,PostgreSQLObject-method SQLKeywords,missing-method isSQLKeyword,PostgreSQLObject,character-method

Make R/S-Plus identifiers into quoted PostgreSQL identifiers

postgresqlBuildTableDefinition()

Build the SQL CREATE TABLE definition as a string

postgresqlDBApply()

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)

postgresqlInitDriver() postgresqlDriverInfo() postgresqlDescribeDriver() postgresqlCloseDriver() postgresqlNewConnection() postgresqlCloneConnection() postgresqlConnectionInfo() postgresqlDescribeConnection() postgresqlCloseConnection() postgresqlExecStatement() postgresqlFetch() postgresqlQuickSQL() postgresqlResultInfo() postgresqlDescribeResult() postgresqlCloseResult() postgresqlDescribeFields() postgresqlDataType() postgresqlReadTable() postgresqlWriteTable() postgresqlpqExec() postgresqlCopyIn() postgresqlgetResult() postgresqlEscapeStrings() postgresqlEscapeBytea() postgresqlUnescapeBytea() postgresqlQuoteId() postgresqlTableRef() postgresqlImportFile() postgresqlTransactionStatement()

Support Functions

coerce-methods summary-methods format-methods show-methods coerce,dbObjectId,integer-method coerce,dbObjectId,numeric-method coerce,dbObjectId,character-method coerce,PostgreSQLObject,PostgreSQLDriver-method coerce,PostgreSQLConnection,PostgreSQLResult-method coerce,PostgreSQLConnection,PostgreSQLDriver-method coerce,PostgreSQLResult,PostgreSQLConnection-method coerce,PostgreSQLResult,PostgreSQLDriver-method format,dbObjectId-method print,dbObjectId-method show,dbObjectId-method summary,PostgreSQLObject-method summary,PostgreSQLDriver-method summary,PostgreSQLConnection-method summary,PostgreSQLResult-method

Summarize an PostgreSQL object