RPostgreSQL: R interface to the PostgreSQL database system

Share:

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/ .

Author
Joe Conway, Dirk Eddelbuettel, Tomoaki Nishiyama, Sameer Kumar Prayaga (during 2008), Neil Tiffin
Date of publication
2016-05-08 23:09:20
Maintainer
Tomoaki Nishiyama <tomoakin@staff.kanazawa-u.ac.jp>
License
GPL-2 | file LICENSE
Version
0.4-1
URLs

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

Files in this package

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