R interface to the PostgreSQL database system


[Up] [Top]

Documentation for package ‘RPostgreSQL’ version 0.4

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)
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
dbCommit-methods 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
dbRollback-methods 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
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
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