{ "_id": "6ae1b6e1327abcdf868642b6", "Package": "RPostgreSQL", "Version": "0.7-8", "Date": "2025-03-28", "Title": "R Interface to the 'PostgreSQL' Database System", "Maintainer": "Tomoaki Nishiyama ", "Description": "Database interface and 'PostgreSQL' driver for 'R'. This\npackage provides a Database Interface 'DBI' compliant driver\nfor 'R' to access 'PostgreSQL' database systems. In order to\nbuild and install this package from source, 'PostgreSQL' itself\nmust be present your system to provide 'PostgreSQL'\nfunctionality via its libraries and header files. These files\nare provided as 'postgresql-devel' package under some Linux\ndistributions. On 'macOS' and 'Microsoft Windows' system the\nattached 'libpq' library source will be used.", "LazyLoad": "true", "License": "GPL-3 | file LICENSE", "Copyright": "Authors listed above, PostgreSQL Global Development Group,\nand The Regents of the University of California", "Collate": "S4R.R zzz.R PostgreSQLSupport.R dbObjectId.R PostgreSQL.R", "URL": "https://github.com/tomoakin/RPostgreSQL,\nhttps://cran.r-project.org/package=DBI,\nhttps://www.postgresql.org", "Authors@R": "c(person(given = \"Joe\",\nfamily = \"Conway\",\nrole = \"aut\"),\nperson(given = \"Dirk\",\nfamily = \"Eddelbuettel\",\nrole = \"aut\"),\nperson(given = \"Tomoaki\",\nfamily = \"Nishiyama\",\nrole = c(\"aut\", \"cre\"),\nemail = \"tomoaki@sci.u-toyama.ac.jp\"),\nperson(given = c(\"Sameer\", \"Kumar\"),\nfamily = \"Prayaga\",\nrole = \"aut\",\ncomment = \"during 2008\"),\nperson(given = \"Neil\",\nfamily = \"Tiffin\",\nrole = \"aut\"))", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-10-28 08:39:08 UTC", "User": "root" }, "Author": "Joe Conway [aut], Dirk Eddelbuettel [aut], Tomoaki Nishiyama\n[aut, cre], Sameer Kumar Prayaga [aut] (during 2008), Neil\nTiffin [aut]", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2025-03-28 08:39:40 UTC", "RemoteUrl": "https://github.com/cran/RPostgreSQL", "RemoteRef": "HEAD", "RemoteSha": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "_user": "cran", "_type": "src", "_file": "RPostgreSQL_0.7-8.tar.gz", "_fileid": "https://r2.ropensci.org/11065828edc18e9fc59c7b7970020a45585dfc41f33ffd77957fe480761de286", "_filesize": 735599, "_sha256": "11065828edc18e9fc59c7b7970020a45585dfc41f33ffd77957fe480761de286", "_expires": "2027-02-05T08:48:31.000Z", "_created": "2026-10-28T08:39:08.000Z", "_published": "2026-10-28T08:48:33.150Z", "_upstream": "https://github.com/cran/RPostgreSQL", "_status": "success", "_maintainer": { "name": "Tomoaki Nishiyama", "email": "tomoaki@sci.u-toyama.ac.jp", "login": "tomoakin", "description": "", "uuid": 363232 }, "_jobs": [ { "job": 122714967786, "time": 79, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "12803076148" }, { "job": 122714967765, "time": 129, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12803386873" }, { "job": 122714967758, "time": 70, "config": "linux-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12802168148" }, { "job": 122714967700, "time": 94, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12802896483" }, { "job": 122713557834, "time": 210, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12803175787" }, { "job": 122714967561, "time": 80, "config": "wasm-release", "r": "4.6.0", "check": "FAIL", "artifact": "" }, { "job": 122714967703, "time": 222, "config": "windows-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "12802936653" }, { "job": 122714967702, "time": 509, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12803057654" }, { "job": 122714967708, "time": 201, "config": "windows-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12803056694" }, { "job": 122714967975, "time": 442, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12803037268" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/40657925458", "_commit": { "id": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "author": "Tomoaki Nishiyama ", "committer": "cran-robot ", "message": "version 0.7-8\n", "time": 1743151180 }, "_distro": "resolute", "_host": "GitHub-Actions", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.4.0", "role": "Depends" }, { "package": "methods", "role": "Depends" }, { "package": "DBI", "version": ">= 0.3", "role": "Depends" } ], "_owner": "cran", "_selfowned": false, "_usedby": 22, "_updates": [], "_tags": [], "_stars": 2, "_contributors": [ { "user": "eddelbuettel", "count": 8, "uuid": 673121 }, { "user": "tomoakin", "count": 8, "uuid": 363232 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "followers": 634, "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 36575, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RPostgreSQL" }, "_mentions": 8, "_devurl": "https://github.com/tomoakin/rpostgresql", "_searchresults": 4, "_topics": [ "postgresql" ], "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/RPostgreSQL.html", "LICENSE" ], "_homeurl": "https://github.com/tomoakin/rpostgresql", "_realowner": "tomoakin", "_cranurl": false, "_releases": [ { "version": "0.1-0", "date": "2008-10-13" }, { "version": "0.1-1", "date": "2008-10-29" }, { "version": "0.1-2", "date": "2008-11-03" }, { "version": "0.1-3", "date": "2008-12-14" }, { "version": "0.1-4", "date": "2009-01-28" }, { "version": "0.1-5", "date": "2009-10-14" }, { "version": "0.1-6", "date": "2009-10-20" }, { "version": "0.1-7", "date": "2010-10-17" }, { "version": "0.2-0", "date": "2011-10-04" }, { "version": "0.2-1", "date": "2011-11-17" }, { "version": "0.3-0", "date": "2011-12-30" }, { "version": "0.3-1", "date": "2012-01-03" }, { "version": "0.3-2", "date": "2012-01-29" }, { "version": "0.3-3", "date": "2012-10-05" }, { "version": "0.4", "date": "2013-03-27" }, { "version": "0.4-1", "date": "2016-05-08" }, { "version": "0.6-2", "date": "2017-06-24" }, { "version": "0.7", "date": "2021-07-27" }, { "version": "0.7-2", "date": "2021-10-06" }, { "version": "0.7-3", "date": "2021-10-22" }, { "version": "0.7-4", "date": "2022-08-09" }, { "version": "0.7-5", "date": "2023-02-10" }, { "version": "0.7-6", "date": "2024-01-11" }, { "version": "0.7-7", "date": "2024-09-30" }, { "version": "0.7-8", "date": "2025-03-28" } ], "_exports": [ "coerce", "dbApply", "dbBegin", "dbCallProc", "dbClearResult", "dbColumnInfo", "dbCommit", "dbConnect", "dbDataType", "dbDisconnect", "dbExistsTable", "dbGetException", "dbGetInfo", "dbGetQuery", "dbGetRowCount", "dbGetRowsAffected", "dbGetStatement", "dbHasCompleted", "dbListConnections", "dbListFields", "dbListResults", "dbListTables", "dbReadTable", "dbRemoveTable", "dbRollback", "dbSendQuery", "dbUnloadDriver", "dbWriteTable", "fetch", "format", "initialize", "isPostgresqlIdCurrent", "isSQLKeyword", "make.db.names", "PostgreSQL", "postgresqlBuildTableDefinition", "postgresqlCloneConnection", "postgresqlCloseConnection", "postgresqlCloseDriver", "postgresqlCloseResult", "postgresqlConnectionInfo", "postgresqlCopyIn", "postgresqlCopyInDataframe", "postgresqlDataType", "postgresqlDBApply", "postgresqlDescribeConnection", "postgresqlDescribeDriver", "postgresqlDescribeFields", "postgresqlDescribeResult", "postgresqlDriverInfo", "postgresqlEscapeBytea", "postgresqlEscapeStrings", "postgresqlExecStatement", "postgresqlFetch", "postgresqlgetResult", "postgresqlImportFile", "postgresqlInitDriver", "postgresqlNewConnection", "postgresqlpqExec", "postgresqlQuickSQL", "postgresqlQuoteId", "postgresqlReadTable", "postgresqlResultInfo", "postgresqlTableRef", "postgresqlUnescapeBytea", "postgresqlWriteTable", "show", "SQLKeywords", "summary" ], "_help": [ { "page": "dbApply", "title": "Apply R/S-Plus functions to remote groups of DBMS rows (experimental)", "topics": [ "dbApply" ] }, { "page": "dbApply-methods", "title": "Apply R/S-Plus functions to remote groups of DBMS rows (experimental)", "topics": [ "dbApply,PostgreSQLResult-method", "dbApply-methods" ] }, { "page": "dbCallProc-methods", "title": "Call an SQL stored procedure", "topics": [ "dbCallProc,PostgreSQLConnection-method", "dbCallProc-methods" ] }, { "page": "dbCommit-methods", "title": "DBMS Transaction Management", "topics": [ "dbBegin,PostgreSQLConnection-method", "dbBegin-method", "dbCommit,PostgreSQLConnection-method", "dbCommit-method", "dbRollback,PostgreSQLConnection-method", "dbRollback-method", "PostgreSQLConnection-method" ] }, { "page": "dbConnect-methods", "title": "Create a connection object to an PostgreSQL DBMS", "topics": [ "dbConnect,character-method", "dbConnect,PostgreSQLConnection-method", "dbConnect,PostgreSQLDriver-method", "dbConnect-methods", "dbDisconnect,PostgreSQLConnection-method", "dbDisconnect-methods" ] }, { "page": "dbDataType-methods", "title": "Determine the SQL Data Type of an S object", "topics": [ "dbDataType,PostgreSQLObject-method", "dbDataType-methods" ] }, { "page": "dbDriver-methods", "title": "PostgreSQL implementation of the Database Interface (DBI) classes and drivers", "topics": [ "dbDriver,character-method", "dbDriver-methods", "dbUnloadDriver,PostgreSQLDriver-method", "dbUnloadDriver-methods" ] }, { "page": "dbGetInfo-methods", "title": "Database interface meta-data", "topics": [ "dbColumnInfo,PostgreSQLResult-method", "dbColumnInfo-methods", "dbGetDBIVersion-methods", "dbGetInfo", "dbGetInfo,PostgreSQLConnection-method", "dbGetInfo,PostgreSQLDriver-method", "dbGetInfo,PostgreSQLObject-method", "dbGetInfo,PostgreSQLResult-method", "dbGetRowCount,PostgreSQLResult-method", "dbGetRowCount-methods", "dbGetRowsAffected,PostgreSQLResult-method", "dbGetRowsAffected-methods", "dbGetStatement,PostgreSQLResult-method", "dbGetStatement-methods", "dbHasCompleted,PostgreSQLResult-method", "dbHasCompleted-methods" ] }, { "page": "dbListTables-methods", "title": "List items from an PostgreSQL DBMS and from objects", "topics": [ "dbListConnections,PostgreSQLDriver-method", "dbListConnections-methods", "dbListFields,PostgreSQLConnection,character-method", "dbListFields,PostgreSQLResult,missing-method", "dbListFields-methods", "dbListResults,PostgreSQLConnection-method", "dbListResults-methods", "dbListTables,PostgreSQLConnection-method", "dbListTables-methods" ] }, { "page": "dbObjectId-class", "title": "Class dbObjectId", "topics": [ "dbObjectId-class" ] }, { "page": "dbReadTable-methods", "title": "Convenience functions for Importing/Exporting DBMS tables", "topics": [ "dbExistsTable,PostgreSQLConnection,character-method", "dbExistsTable-methods", "dbReadTable,PostgreSQLConnection,character-method", "dbReadTable-methods", "dbRemoveTable,PostgreSQLConnection,character-method", "dbRemoveTable-methods", "dbWriteTable,PostgreSQLConnection,character,character-method", "dbWriteTable,PostgreSQLConnection,character,data.frame-method", "dbWriteTable-methods" ] }, { "page": "dbSendQuery-methods", "title": "Execute a statement on a given database connection", "topics": [ "dbClearResult,PostgreSQLResult-method", "dbClearResult-methods", "dbGetException,PostgreSQLConnection-method", "dbGetException,PostgreSQLResult-method", "dbGetException-methods", "dbGetQuery,PostgreSQLConnection,character-method", "dbGetQuery-methods", "dbSendQuery,PostgreSQLConnection,character-method", "dbSendQuery-methods" ] }, { "page": "dbSetDataMappings-methods", "title": "Set data mappings between PostgreSQL and R/S-Plus", "topics": [ "dbSetDataMappings,PostgreSQLResult,data.frame-method", "dbSetDataMappings-methods" ] }, { "page": "fetch-methods", "title": "Fetch records from a previously executed query", "topics": [ "fetch,PostgreSQLResult,missing-method", "fetch,PostgreSQLResult,numeric-method", "fetch-methods" ] }, { "page": "isPostgresqlIdCurrent", "title": "Check whether a database handle object is valid or not", "topics": [ "isPostgresqlIdCurrent" ] }, { "page": "make.db.names-methods", "title": "Make R/S-Plus identifiers into quoted PostgreSQL identifiers", "topics": [ "isSQLKeyword,PostgreSQLObject,character-method", "isSQLKeyword-methods", "make.db.names,PostgreSQLObject,character-method", "SQLKeywords,missing-method", "SQLKeywords,PostgreSQLObject-method", "SQLKeywords-methods" ] }, { "page": "PostgreSQL", "title": "Instantiate a PostgreSQL client from the current R or S-Plus session", "topics": [ "PostgreSQL" ] }, { "page": "postgresqlBuildTableDefinition", "title": "Build the SQL CREATE TABLE definition as a string", "topics": [ "postgresqlBuildTableDefinition" ] }, { "page": "PostgreSQLConnection-class", "title": "Class PostgreSQLConnection", "topics": [ "PostgreSQLConnection-class" ] }, { "page": "postgresqlDBApply", "title": "Apply R/S-Plus functions to remote groups of DBMS rows (experimental)", "topics": [ "postgresqlDBApply" ] }, { "page": "PostgreSQLDriver-class", "title": "Class PostgreSQLDriver", "topics": [ "PostgreSQLDriver-class" ] }, { "page": "PostgreSQLObject-class", "title": "Class PostgreSQLObject", "topics": [ "PostgreSQLObject-class" ] }, { "page": "PostgreSQLResult-class", "title": "Class PostgreSQLResult", "topics": [ "PostgreSQLResult-class" ] }, { "page": "postgresqlSupport", "title": "Support Functions", "topics": [ ".conflicts.OK", ".PostgreSQL.NA.string", ".PostgreSQLPkgName", ".PostgreSQLPkgRCS", ".PostgreSQLPkgVersion", ".PostgreSQLSQLKeywords", "postgresqlCloneConnection", "postgresqlCloseConnection", "postgresqlCloseDriver", "postgresqlCloseResult", "postgresqlConnectionInfo", "postgresqlCopyIn", "postgresqlCopyInDataframe", "postgresqlDataType", "postgresqlDescribeConnection", "postgresqlDescribeDriver", "postgresqlDescribeFields", "postgresqlDescribeResult", "postgresqlDriverInfo", "postgresqlEscapeBytea", "postgresqlEscapeStrings", "postgresqlExecStatement", "postgresqlFetch", "postgresqlgetResult", "postgresqlImportFile", "postgresqlInitDriver", "postgresqlNewConnection", "postgresqlpqExec", "postgresqlQuickSQL", "postgresqlQuoteId", "postgresqlReadTable", "postgresqlResultInfo", "postgresqlTableRef", "postgresqlTransactionStatement", "postgresqlUnescapeBytea", "postgresqlWriteTable" ] }, { "page": "summary-methods", "title": "Summarize an PostgreSQL object", "topics": [ "coerce,dbObjectId,character-method", "coerce,dbObjectId,integer-method", "coerce,dbObjectId,numeric-method", "coerce,PostgreSQLConnection,PostgreSQLDriver-method", "coerce,PostgreSQLConnection,PostgreSQLResult-method", "coerce,PostgreSQLObject,PostgreSQLDriver-method", "coerce,PostgreSQLResult,PostgreSQLConnection-method", "coerce,PostgreSQLResult,PostgreSQLDriver-method", "coerce-methods", "format,dbObjectId-method", "format-methods", "print,dbObjectId-method", "show,dbObjectId-method", "show-methods", "summary,PostgreSQLConnection-method", "summary,PostgreSQLDriver-method", "summary,PostgreSQLObject-method", "summary,PostgreSQLResult-method", "summary-methods" ] } ], "_rundeps": [ "DBI" ], "_sysdeps": [ { "shlib": "libpq", "package": "libpq5", "headers": "libpq-dev", "source": "postgresql", "version": "18.6-0ubuntu0.26.04.1", "name": "postgresql", "homepage": "http://www.postgresql.org/", "description": "PostgreSQL C client library" } ], "_score": 5.586848252995142, "_indexed": false, "_nocasepkg": "rpostgresql", "_universes": [ "cran" ], "_indexurl": "https://tomoakin.r-universe.dev/RPostgreSQL", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.7-8", "date": "2026-10-28T08:40:44.000Z", "distro": "resolute", "arch": "aarch64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "https://r2.ropensci.org/c5ae88d31326d9a054b3b0509c95353f8cd2d6457750eeb6f403093f6bb094e7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40657925458" }, { "r": "4.7.0", "os": "linux", "version": "0.7-8", "date": "2026-10-28T08:41:33.000Z", "distro": "resolute", "arch": "x86_64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "https://r2.ropensci.org/974ad38a8e6b28bed2e8e861ff4644296fbda2062ac020510a57d2f2dcdf23ec", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40657925458" }, { "r": "4.6.1", "os": "linux", "version": "0.7-8", "date": "2026-10-28T08:40:39.000Z", "distro": "resolute", "arch": "aarch64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "https://r2.ropensci.org/eb4b977271a6838ed24a2d0d402b3c26491c3b736aac98f9616063535a8575db", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40657925458" }, { "r": "4.6.1", "os": "linux", "version": "0.7-8", "date": "2026-10-28T08:40:56.000Z", "distro": "resolute", "arch": "x86_64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "https://r2.ropensci.org/422eb1a7a82a8643b6f8c32fdd7655d455d60b50ce494ffdb731de6e8e4713ee", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40657925458" }, { "r": "4.7.0", "os": "win", "version": "0.7-8", "date": "2026-10-28T08:42:47.000Z", "arch": "aarch64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "https://r2.ropensci.org/6c38b9eaf4a2d57487d7b8da45e077935b82ec76db736a8a689be0a0f6d09c34", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40657925458" }, { "r": "4.7.0", "os": "win", "version": "0.7-8", "date": "2026-10-28T08:45:22.000Z", "arch": "x86_64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "https://r2.ropensci.org/622b31f361ed37d5c8acf075fdfbb64ce4fa8c2981f4c66b3bd7d7d880ba13f5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40657925458" }, { "r": "4.6.1", "os": "win", "version": "0.7-8", "date": "2026-10-28T08:42:25.000Z", "arch": "aarch64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "https://r2.ropensci.org/92e925a77b0b48f1246469049779ba54ded5a8962143a343aa395ec6c8b6537e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40657925458" }, { "r": "4.6.1", "os": "win", "version": "0.7-8", "date": "2026-10-28T08:45:51.000Z", "arch": "x86_64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "https://r2.ropensci.org/707fadba6e664a0752fdba2b950d0e4493d56d16d1e1a9791d6c4ad0c4819145", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40657925458" } ] }