{ "_id": "6a26a27e24555f66ed5222a3", "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-06-08 11:04:45 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", "MD5sum": "11cb3e9b4f8da9fb2991ec0e3567b51d", "_user": "cran", "_type": "src", "_file": "RPostgreSQL_0.7-8.tar.gz", "_fileid": "2be35a9af6357c86423b22556af16e5bafdc0c936d0a19c49bd9bda120584622", "_filesize": 736463, "_sha256": "2be35a9af6357c86423b22556af16e5bafdc0c936d0a19c49bd9bda120584622", "_created": "2026-06-08T11:04:45.000Z", "_published": "2026-06-08T11:07:42.971Z", "_distro": "noble", "_jobs": [ { "job": 80079668065, "time": 135, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "7478450040" }, { "job": 80079668145, "time": 129, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7478447289" }, { "job": 80079668123, "time": 125, "config": "linux-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7478446875" }, { "job": 80079668178, "time": 139, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7478450426" }, { "job": 80079155760, "time": 179, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7478402301" }, { "job": 80079668098, "time": 98, "config": "wasm-release", "r": "4.6.0", "check": "FAIL", "artifact": "" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/27133197894", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/RPostgreSQL", "_commit": { "id": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "author": "Tomoaki Nishiyama ", "committer": "cran-robot ", "message": "version 0.7-8\n", "time": 1743151180 }, "_maintainer": { "name": "Tomoaki Nishiyama", "email": "tomoaki@sci.u-toyama.ac.jp", "login": "tomoakin", "description": "", "uuid": 363232 }, "_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": 24, "_updates": [], "_tags": [], "_stars": 2, "_contributors": [ { "user": "eddelbuettel", "count": 8, "uuid": 673121 }, { "user": "tomoakin", "count": 8, "uuid": 363232 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 37018, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RPostgreSQL" }, "_mentions": 8, "_devurl": "https://github.com/tomoakin/rpostgresql", "_searchresults": 5216, "_topics": [ "postgresql" ], "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/RPostgreSQL.html", "manual.pdf" ], "_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": "16.14-0ubuntu0.24.04.1", "name": "postgresql", "homepage": "http://www.postgresql.org/", "description": "PostgreSQL C client library" } ], "_score": 8.347203012899273, "_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-06-08T11:07:12.000Z", "distro": "noble", "arch": "aarch64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "a1fd0595a7b7b778bb6f191203bf8330b48f13bbe96447c16d963cf4e0e99c94", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27133197894" }, { "r": "4.7.0", "os": "linux", "version": "0.7-8", "date": "2026-06-08T11:07:02.000Z", "distro": "noble", "arch": "x86_64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "e2d93b8d87910cdfbc1799373106f5bba3639eeeb9580bd8a3aa266bac61d62c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27133197894" }, { "r": "4.6.0", "os": "linux", "version": "0.7-8", "date": "2026-06-08T11:07:02.000Z", "distro": "noble", "arch": "aarch64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "1d0fa68e832033241f599c58606ef02fd2bd7dea5547cbffa3c173883f4e2cc1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27133197894" }, { "r": "4.6.0", "os": "linux", "version": "0.7-8", "date": "2026-06-08T11:07:09.000Z", "distro": "noble", "arch": "x86_64", "commit": "9ddd39bb8dc60f284c9546da65b5d2717bfa56fb", "fileid": "4b0c7364b115dc5b517c100a52fa37aaa959052ee1f7eb9c0f02219028990a5f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27133197894" } ] }