R interface to the PostgreSQL database system


[Package List] [Top]

Documentation for package ‘RPostgreSQL’ version 0.1-4

User Guides and Package Vignettes

Read overview or browse directory.

Help Pages

C D F I M P S

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

-- C --

coerce,dbObjectId,character-method Summarize an PostgreSQL object
coerce,dbObjectId,integer-method Summarize an PostgreSQL object
coerce,dbObjectId,numeric-method Summarize an PostgreSQL object
coerce,PostgreSQLConnection,PostgreSQLDriver-method Summarize an PostgreSQL object
coerce,PostgreSQLConnection,PostgreSQLResult-method Summarize an PostgreSQL object
coerce,PostgreSQLObject,PostgreSQLDriver-method Summarize an PostgreSQL object
coerce,PostgreSQLResult,PostgreSQLConnection-method Summarize an PostgreSQL object
coerce,PostgreSQLResult,PostgreSQLDriver-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,PostgreSQLResult-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)
dbBeginTransaction DBMS Transaction Management
dbBeginTransaction,PostgreSQLConnection-method DBMS Transaction Management
dbBeginTransaction-methods DBMS Transaction Management
dbBuildTableDefinition Build the SQL CREATE TABLE definition as a string
dbCallProc,PostgreSQLConnection-method Call an SQL stored procedure
dbCallProc-methods Call an SQL stored procedure
dbClearResult,PostgreSQLResult-method Execute a statement on a given database connection
dbClearResult-methods Execute a statement on a given database connection
dbColumnInfo,PostgreSQLResult-method Database interface meta-data
dbColumnInfo-methods Database interface meta-data
dbCommit,PostgreSQLConnection-method DBMS Transaction Management
dbCommit-methods DBMS Transaction Management
dbConnect,character-method Create a connection object to an PostgreSQL DBMS
dbConnect,PostgreSQLConnection-method Create a connection object to an PostgreSQL DBMS
dbConnect,PostgreSQLDriver-method Create a connection object to an PostgreSQL DBMS
dbConnect-methods Create a connection object to an PostgreSQL DBMS
dbDataType,PostgreSQLObject-method Determine the SQL Data Type of an S object
dbDataType-methods Determine the SQL Data Type of an S object
dbDisconnect,PostgreSQLConnection-method Create a connection object to an PostgreSQL DBMS
dbDisconnect-methods Create a connection object to an PostgreSQL DBMS
dbDriver,character-method PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbDriver-methods PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbExistsTable,PostgreSQLConnection,character-method Convenience functions for Importing/Exporting DBMS tables
dbExistsTable-methods Convenience functions for Importing/Exporting DBMS tables
dbGetDBIVersion-methods Database interface meta-data
dbGetException,PostgreSQLConnection-method Execute a statement on a given database connection
dbGetException,PostgreSQLResult-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,PostgreSQLConnection-method Database interface meta-data
dbGetInfo,PostgreSQLDriver-method Database interface meta-data
dbGetInfo,PostgreSQLObject-method Database interface meta-data
dbGetInfo,PostgreSQLResult-method Database interface meta-data
dbGetQuery,PostgreSQLConnection,character-method Execute a statement on a given database connection
dbGetQuery-methods Execute a statement on a given database connection
dbGetRowCount,PostgreSQLResult-method Database interface meta-data
dbGetRowCount-methods Database interface meta-data
dbGetRowsAffected,PostgreSQLResult-method Database interface meta-data
dbGetRowsAffected-methods Database interface meta-data
dbGetStatement,PostgreSQLResult-method Database interface meta-data
dbGetStatement-methods Database interface meta-data
dbHasCompleted,PostgreSQLResult-method Database interface meta-data
dbHasCompleted-methods Database interface meta-data
dbListConnections,PostgreSQLDriver-method List items from an PostgreSQL DBMS and from objects
dbListConnections-methods List items from an PostgreSQL DBMS and from objects
dbListFields,PostgreSQLConnection,character-method List items from an PostgreSQL DBMS and from objects
dbListFields,PostgreSQLResult,missing-method List items from an PostgreSQL DBMS and from objects
dbListFields-methods List items from an PostgreSQL DBMS and from objects
dbListResults,PostgreSQLConnection-method List items from an PostgreSQL DBMS and from objects
dbListResults-methods List items from an PostgreSQL DBMS and from objects
dbListTables,PostgreSQLConnection-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,PostgreSQLConnection,character-method Convenience functions for Importing/Exporting DBMS tables
dbReadTable-methods Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable,PostgreSQLConnection,character-method Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-methods Convenience functions for Importing/Exporting DBMS tables
dbRollback,PostgreSQLConnection-method DBMS Transaction Management
dbRollback-methods DBMS Transaction Management
dbSendQuery,PostgreSQLConnection,character-method Execute a statement on a given database connection
dbSendQuery-methods Execute a statement on a given database connection
dbSetDataMappings,PostgreSQLResult,data.frame-method Set data mappings between PostgreSQL and R/S-Plus
dbSetDataMappings-methods Set data mappings between PostgreSQL and R/S-Plus
dbUnloadDriver,PostgreSQLDriver-method PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbUnloadDriver-methods PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbWriteTable,PostgreSQLConnection,character,character-method Convenience functions for Importing/Exporting DBMS tables
dbWriteTable,PostgreSQLConnection,character,data.frame-method Convenience functions for Importing/Exporting DBMS tables
dbWriteTable-methods Convenience functions for Importing/Exporting DBMS tables

-- F --

fetch,PostgreSQLResult,missing-method Fetch records from a previously executed query
fetch,PostgreSQLResult,numeric-method Fetch records from a previously executed query
fetch-methods Fetch records from a previously executed query
format,dbObjectId-method Summarize an PostgreSQL object
format-methods Summarize an PostgreSQL object

-- I --

isIdCurrent Check whether a database handle object is valid or not
isSQLKeyword,PostgreSQLObject,character-method Make R/S-Plus identifiers into legal SQL identifiers
isSQLKeyword-methods Make R/S-Plus identifiers into legal SQL identifiers

-- M --

make.db.names,PostgreSQLObject,character-method Make R/S-Plus identifiers into legal SQL identifiers

-- P --

PostgreSQL Instantiate a PostgreSQL client from the current R or S-Plus session
postgresqlCloneConnection Support Functions
postgresqlCloseConnection Support Functions
postgresqlCloseDriver Support Functions
postgresqlCloseResult Support Functions
PostgreSQLConnection-class Class PostgreSQLConnection
postgresqlConnectionInfo 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
postgresqlExecStatement Support Functions
postgresqlFetch Support Functions
postgresqlImportFile Support Functions
postgresqlInitDriver Support Functions
postgresqlNewConnection Support Functions
PostgreSQLObject-class Class PostgreSQLObject
postgresqlQuickSQL Support Functions
postgresqlReadTable Support Functions
PostgreSQLResult-class Class PostgreSQLResult
postgresqlResultInfo Support Functions
postgresqlTransactionStatement Support Functions
postgresqlWriteTable Support Functions
print,dbObjectId-method Summarize an PostgreSQL object

-- S --

show,dbObjectId-method Summarize an PostgreSQL object
show-methods Summarize an PostgreSQL object
SQLKeywords,missing-method Make R/S-Plus identifiers into legal SQL identifiers
SQLKeywords,PostgreSQLObject-method Make R/S-Plus identifiers into legal SQL identifiers
SQLKeywords-methods Make R/S-Plus identifiers into legal SQL identifiers
summary,PostgreSQLConnection-method Summarize an PostgreSQL object
summary,PostgreSQLDriver-method Summarize an PostgreSQL object
summary,PostgreSQLObject-method Summarize an PostgreSQL object
summary,PostgreSQLResult-method Summarize an PostgreSQL object
summary-methods Summarize an PostgreSQL object