RPostgreSQL: R interface to the PostgreSQL database system

Database interface and PostgreSQL driver for R This package provides a Database Interface (DBI) compliant driver for R to access PostgreSQL database systems. . In order to build and install this package from source, PostgreSQL itself must be present your system to provide PostgreSQL functionality via its libraries and header files. These files are provided as postgresql-devel package under some Linux distributions. . On Microsoft Windows system the attached libpq library source will be used. . A wiki and issue tracking system for the package are available at Google Code at https://code.google.com/p/rpostgresql/ .

Install the latest version of this package by entering the following in R:
install.packages("RPostgreSQL")
AuthorJoe Conway, Dirk Eddelbuettel, Tomoaki Nishiyama, Sameer Kumar Prayaga (during 2008), Neil Tiffin
Date of publication2016-05-08 23:09:20
MaintainerTomoaki Nishiyama <tomoakin@staff.kanazawa-u.ac.jp>
LicenseGPL-2 | file LICENSE
Version0.4-1
https://code.google.com/p/rpostgresql/, http://www.stat.bell-labs.com/RS-DBI
http://www.postgresql.org

View on CRAN

Man pages

dbApply: Apply R/S-Plus functions to remote groups of DBMS rows...

dbApply-methods: Apply R/S-Plus functions to remote groups of DBMS rows...

dbCallProc-methods: Call an SQL stored procedure

dbCommit-methods: DBMS Transaction Management

dbConnect-methods: Create a connection object to an PostgreSQL DBMS

dbDataType-methods: Determine the SQL Data Type of an S object

dbDriver-methods: PostgreSQL implementation of the Database Interface (DBI)...

dbGetInfo-methods: Database interface meta-data

dbListTables-methods: List items from an PostgreSQL DBMS and from objects

dbObjectId-class: Class dbObjectId

dbReadTable-methods: Convenience functions for Importing/Exporting DBMS tables

dbSendQuery-methods: Execute a statement on a given database connection

dbSetDataMappings-methods: Set data mappings between PostgreSQL and R/S-Plus

fetch-methods: Fetch records from a previously executed query

isPostgresqlIdCurrent: Check whether a database handle object is valid or not

make.db.names-methods: Make R/S-Plus identifiers into quoted PostgreSQL identifiers

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

postgresqlBuildTableDefinition: Build the SQL CREATE TABLE definition as a string

PostgreSQLConnection-class: Class PostgreSQLConnection

postgresqlDBApply: Apply R/S-Plus functions to remote groups of DBMS rows...

PostgreSQLDriver-class: Class PostgreSQLDriver

PostgreSQLObject-class: Class PostgreSQLObject

PostgreSQLResult-class: Class PostgreSQLResult

postgresqlSupport: Support Functions

S4R: R compatibility with S version 4/Splus5+ support functions

summary-methods: Summarize an PostgreSQL object

Functions

coerce,dbObjectId,character-method Man page
coerce,dbObjectId,integer-method Man page
coerce,dbObjectId,numeric-method Man page
coerce-methods Man page
coerce,PostgreSQLConnection,PostgreSQLDriver-method Man page
coerce,PostgreSQLConnection,PostgreSQLResult-method Man page
coerce,PostgreSQLObject,PostgreSQLDriver-method Man page
coerce,PostgreSQLResult,PostgreSQLConnection-method Man page
coerce,PostgreSQLResult,PostgreSQLDriver-method Man page
.conflicts.OK Man page
dbApply Man page
dbApply-methods Man page
dbApply,PostgreSQLResult-method Man page
dbCallProc-methods Man page
dbCallProc,PostgreSQLConnection-method Man page
dbClearResult-methods Man page
dbClearResult,PostgreSQLResult-method Man page
dbColumnInfo-methods Man page
dbColumnInfo,PostgreSQLResult-method Man page
dbCommit-methods Man page
dbCommit,PostgreSQLConnection-method Man page
dbConnect,character-method Man page
dbConnect-methods Man page
dbConnect,PostgreSQLConnection-method Man page
dbConnect,PostgreSQLDriver-method Man page
dbDataType-methods Man page
dbDataType,PostgreSQLObject-method Man page
dbDisconnect-methods Man page
dbDisconnect,PostgreSQLConnection-method Man page
dbDriver,character-method Man page
dbDriver-methods Man page
dbExistsTable-methods Man page
dbExistsTable,PostgreSQLConnection,character-method Man page
dbGetDBIVersion-methods Man page
dbGetException-methods Man page
dbGetException,PostgreSQLConnection-method Man page
dbGetException,PostgreSQLResult-method Man page
dbGetInfo Man page
dbGetInfo,PostgreSQLConnection-method Man page
dbGetInfo,PostgreSQLDriver-method Man page
dbGetInfo,PostgreSQLObject-method Man page
dbGetInfo,PostgreSQLResult-method Man page
dbGetQuery-methods Man page
dbGetQuery,PostgreSQLConnection,character-method Man page
dbGetRowCount-methods Man page
dbGetRowCount,PostgreSQLResult-method Man page
dbGetRowsAffected-methods Man page
dbGetRowsAffected,PostgreSQLResult-method Man page
dbGetStatement-methods Man page
dbGetStatement,PostgreSQLResult-method Man page
dbHasCompleted-methods Man page
dbHasCompleted,PostgreSQLResult-method Man page
dbListConnections-methods Man page
dbListConnections,PostgreSQLDriver-method Man page
dbListFields-methods Man page
dbListFields,PostgreSQLConnection,character-method Man page
dbListFields,PostgreSQLResult,missing-method Man page
dbListResults-methods Man page
dbListResults,PostgreSQLConnection-method Man page
dbListTables-methods Man page
dbListTables,PostgreSQLConnection-method Man page
dbObjectId-class Man page
dbReadTable-methods Man page
dbReadTable,PostgreSQLConnection,character-method Man page
dbRemoveTable-methods Man page
dbRemoveTable,PostgreSQLConnection,character-method Man page
dbRollback-methods Man page
dbRollback,PostgreSQLConnection-method Man page
dbSendQuery-methods Man page
dbSendQuery,PostgreSQLConnection,character-method Man page
dbSetDataMappings-methods Man page
dbSetDataMappings,PostgreSQLResult,data.frame-method Man page
dbUnloadDriver-methods Man page
dbUnloadDriver,PostgreSQLDriver-method Man page
dbWriteTable-methods Man page
dbWriteTable,PostgreSQLConnection,character,character-method Man page
dbWriteTable,PostgreSQLConnection,character,data.frame-method Man page
ErrorClass Man page
fetch-methods Man page
fetch,PostgreSQLResult-method Man page
fetch,PostgreSQLResult,missing-method Man page
fetch,PostgreSQLResult,numeric-method Man page
format,dbObjectId-method Man page
format-methods Man page
isPostgresqlIdCurrent Man page
isSQLKeyword-methods Man page
isSQLKeyword,PostgreSQLObject,character-method Man page
make.db.names,PostgreSQLObject,character-method Man page
PostgreSQL Man page
postgresqlBuildTableDefinition Man page
postgresqlCloneConnection Man page
postgresqlCloseConnection Man page
postgresqlCloseDriver Man page
postgresqlCloseResult Man page
PostgreSQLConnection-class Man page
postgresqlConnectionInfo Man page
PostgreSQLConnection-method Man page
postgresqlCopyIn Man page
postgresqlCopyInDataframe Man page
postgresqlDataType Man page
postgresqlDBApply Man page
postgresqlDescribeConnection Man page
postgresqlDescribeDriver Man page
postgresqlDescribeFields Man page
postgresqlDescribeResult Man page
PostgreSQLDriver-class Man page
postgresqlDriverInfo Man page
postgresqlEscapeStrings Man page
postgresqlExecStatement Man page
postgresqlFetch Man page
postgresqlgetResult Man page
postgresqlImportFile Man page
postgresqlInitDriver Man page
.PostgreSQL.NA.string Man page
postgresqlNewConnection Man page
PostgreSQLObject-class Man page
.PostgreSQLPkgName Man page
.PostgreSQLPkgRCS Man page
.PostgreSQLPkgVersion Man page
postgresqlpqExec Man page
postgresqlQuickSQL Man page
postgresqlQuoteId Man page
postgresqlReadTable Man page
PostgreSQLResult-class Man page
postgresqlResultInfo Man page
.PostgreSQLSQLKeywords Man page
postgresqlTableRef Man page
postgresqlTransactionStatement Man page
postgresqlWriteTable Man page
print,dbObjectId-method Man page
show,dbObjectId-method Man page
show-methods Man page
SQLKeywords-methods Man page
SQLKeywords,missing-method Man page
SQLKeywords,PostgreSQLObject-method Man page
summary-methods Man page
summary,PostgreSQLConnection-method Man page
summary,PostgreSQLDriver-method Man page
summary,PostgreSQLObject-method Man page
summary,PostgreSQLResult-method Man page
usingR Man page

Files

inst
inst/TODO
inst/ANNOUNCEMENT
inst/devTests
inst/devTests/PostgreSQLDataTypeTest.r
inst/devTests/copyTest.sh
inst/devTests/datetime.r inst/devTests/demo.r inst/devTests/timeTypeComparison.r inst/devTests/transactionManagement.r inst/devTests/typeTest.r
inst/NEWS
inst/README
inst/THANKS
inst/doc
inst/doc/DBI.pdf
configure.in
tests
tests/escape.Rout.save
tests/dbListFields.R
tests/dbColumnInfo.Rout.save
tests/dbTransactionTests.Rout.save
tests/selectWithAlias.R tests/dataTypeTests.R tests/dbExistsqc.R
tests/dateTZ.Rout.save
tests/dbWriteTableFailTest.Rout.save
tests/dbWriteTabletypes.Rout.save
tests/dbGetQueryParams.R tests/selectWhereZero.R tests/openSendQuery.R tests/createTableMixedCaseTest.R
tests/openSendQuery.Rout.save
tests/dbWriteTableSchema.Rout.save
tests/selectWhereZero.Rout.save
tests/dbExistsIssue.R
tests/dbtemptable.Rout.save
tests/dbtemptable.R tests/escape.R
tests/datetimestampwrite.Rout.save
tests/selectWithAlias.Rout.save
tests/dateTZ.R tests/dbWriteTableSchema.R tests/dbTransactionTests.R
tests/dbGetQueryParams.Rout.save
tests/unknowntype.Rout.save
tests/dbWriteTableTest.Rout.save
tests/loadDriverAndConnect.R
tests/dbExistsIssue.Rout.save
tests/datetimestampwrite.R
tests/dbExistsqc.Rout.save
tests/dbExistsq.R
tests/dataTypeTests.Rout.save
tests/dbExistsq.Rout.save
tests/unknowntype.R tests/dbWriteTableTest.R
tests/dbListFields.Rout.save
tests/loadDriverAndConnect.Rout.save
tests/datetimeTests.Rout.save
tests/datetimeTests.R
tests/createTableMixedCaseTest.Rout.save
tests/dbColumnInfo.R tests/connectWithNull.R tests/dbWriteTabletypes.R
tests/connectWithNull.Rout.save
tests/dbWriteTableFailTest.R
src
src/S4R.h
src/RS-pgsql-pqexec.c
src/libpq
src/libpq/wininclude
src/libpq/wininclude/pwd.h
src/libpq/wininclude/netdb.h
src/libpq/wininclude/arpa
src/libpq/wininclude/arpa/inet.h
src/libpq/wininclude/sys
src/libpq/wininclude/sys/socket.h
src/libpq/wininclude/sys/wait.h
src/libpq/wininclude/netinet
src/libpq/wininclude/netinet/in.h
src/libpq/fe-protocol2.c
src/libpq/libpq.rc.in
src/libpq/pqsignal.c
src/libpq/libpq-fe.h
src/libpq/libpqddll.def
src/libpq/libpq-events.h
src/libpq/libpq.rc
src/libpq/COPYRIGHT
src/libpq/libpq
src/libpq/libpq/pqcomm.h
src/libpq/libpq/libpq-fs.h
src/libpq/libpq/libpq-be.h
src/libpq/libpq/hba.h
src/libpq/libpq/pqsignal.h
src/libpq/libpq/pqformat.h
src/libpq/libpq/auth.h
src/libpq/libpq/libpq.h
src/libpq/libpq/be-fsstubs.h
src/libpq/libpq/md5.h
src/libpq/libpq/ip.h
src/libpq/libpq/crypt.h
src/libpq/Makefile.port
src/libpq/Makefile.global.darwin
src/libpq/pgsleep.c
src/libpq/Makefile.darwin
src/libpq/getaddrinfo.h
src/libpq/pthread-win32.c
src/libpq/fe-auth.h
src/libpq/wchar.c
src/libpq/fe-auth.c
src/libpq/fe-secure.c
src/libpq/pg_config_paths.h.darwin
src/libpq/pg_config_os.h.darwin
src/libpq/noblock.c
src/libpq/fe-exec.c
src/libpq/Makefile.global.win64
src/libpq/bcc32.mak
src/libpq/blibpqdll.def
src/libpq/fe-protocol3.c
src/libpq/pqsignal.h
src/libpq/md5.c
src/libpq/fe-misc.c
src/libpq/ip.c
src/libpq/c.h
src/libpq/pg_service.conf.sample
src/libpq/Makefile.win
src/libpq/win32setlocale.c
src/libpq/crypt.c
src/libpq/pqexpbuffer.h
src/libpq/README
src/libpq/getaddrinfo.c
src/libpq/win32.mak
src/libpq/postgres_fe.h
src/libpq/thread.c
src/libpq/win32error.c
src/libpq/fe-connect.c
src/libpq/libpq-int.h
src/libpq/inet_aton.c
src/libpq/libpq-dist.rc
src/libpq/win32.c
src/libpq/port.h
src/libpq/exports.txt
src/libpq/pg_config_manual.h
src/libpq/pgstrcasecmp.c
src/libpq/chklocale.c
src/libpq/pqexpbuffer.c
src/libpq/postgres_ext.h
src/libpq/libpq-events.c
src/libpq/Makefile.shlib
src/libpq/open.c
src/libpq/libpqdll.def
src/libpq/pthread-win32.h
src/libpq/pg_config_paths.h.win
src/libpq/pg_config.h.win
src/libpq/fe-print.c
src/libpq/pg_config.h.darwin
src/libpq/Makefile.port.darwin
src/libpq/strlcpy.c
src/libpq/pg_config_os.h.win
src/libpq/mb
src/libpq/mb/pg_wchar.h
src/libpq/win32.h
src/libpq/Makefile.global.win32
src/libpq/encnames.c
src/libpq/nls.mk
src/libpq/fe-lobj.c
src/libpq/snprintf.c
src/libpq/inet_net_ntop.c
src/RS-DBI.h
src/RS-pgsql-getResult.c
src/RS-PostgreSQL.h
src/RS-pgsql-pqexecparams.c
src/RS-pgsql-copy.c
src/RS-PQescape.c
src/RS-DBI.c
src/Makevars.in
src/RS-PostgreSQL.c
src/Makevars.win
NAMESPACE
install-sh
R
R/PostgreSQLSupport.R R/PostgreSQL.R R/dbObjectId.R R/S4R.R R/zzz.R
MD5
DESCRIPTION
config.guess
configure
ChangeLog
man
man/PostgreSQLResult-class.Rd man/PostgreSQLObject-class.Rd man/summary-methods.Rd man/dbListTables-methods.Rd man/postgresqlDBApply.Rd man/postgresqlBuildTableDefinition.Rd man/isPostgresqlIdCurrent.Rd man/PostgreSQLDriver-class.Rd man/S4R.Rd man/dbObjectId-class.Rd man/make.db.names-methods.Rd man/dbSendQuery-methods.Rd man/dbCommit-methods.Rd man/PostgreSQL.Rd man/PostgreSQLConnection-class.Rd man/dbReadTable-methods.Rd man/postgresqlSupport.Rd man/dbGetInfo-methods.Rd man/dbDriver-methods.Rd man/dbApply-methods.Rd man/fetch-methods.Rd man/dbSetDataMappings-methods.Rd man/dbApply.Rd man/dbDataType-methods.Rd man/dbConnect-methods.Rd man/dbCallProc-methods.Rd
configure.win
config.sub
cleanup
LICENSE

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.