{ "_id": "6a1fca44b401979e73432397", "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-01 06:48:40 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://tomoakin.r-universe.dev", "Date/Publication": "2025-03-28 06:57:25 UTC", "RemoteUrl": "https://github.com/tomoakin/rpostgresql", "RemoteRef": "HEAD", "RemoteSha": "e8a32401d13549f8b1ffc8bc78ca572891495008", "RemoteSubdir": "RPostgreSQL", "MD5sum": "c416e4d5995f7aad824f74099d90d7f8", "_user": "tomoakin", "_type": "src", "_file": "RPostgreSQL_0.7-8.tar.gz", "_fileid": "f7d86e74adb0c07c90f8118d927fb4ac66fc80db0929ed6bf63b4389cf7109a5", "_filesize": 737519, "_sha256": "f7d86e74adb0c07c90f8118d927fb4ac66fc80db0929ed6bf63b4389cf7109a5", "_created": "2026-06-01T06:48:40.000Z", "_published": "2026-06-03T06:31:32.215Z", "_distro": "noble", "_jobs": [ { "job": 79235281632, "time": 103, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "7325069595" }, { "job": 79235281650, "time": 109, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7325071195" }, { "job": 79235281550, "time": 98, "config": "linux-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7325068526" }, { "job": 79235281542, "time": 107, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7325070805" }, { "job": 79235281244, "time": 82, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "FAIL", "artifact": "" }, { "job": 79235281716, "time": 325, "config": "macos-oldrel-x86_64", "r": "4.5.3", "check": "WARNING", "artifact": "7325127763" }, { "job": 79235281592, "time": 144, "config": "macos-release-arm64", "r": "4.6.0", "check": "WARNING", "artifact": "7325137119" }, { "job": 79235281602, "time": 297, "config": "macos-release-x86_64", "r": "4.6.0", "check": "WARNING", "artifact": "7325157994" }, { "job": 79235281301, "time": 138, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7325042703" }, { "job": 79235281038, "time": 97, "config": "wasm-release", "r": "4.6.0", "check": "FAIL", "artifact": "" }, { "job": 79235281440, "time": 135, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7325078391" }, { "job": 79235281910, "time": 118, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7325073487" }, { "job": 79235281539, "time": 137, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7325079292" } ], "_buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/tomoakin/rpostgresql", "_commit": { "id": "e8a32401d13549f8b1ffc8bc78ca572891495008", "author": "Tomoaki Nishiyama ", "committer": "Tomoaki Nishiyama ", "message": "Drop PQprint() and related routines\n", "time": 1743145045 }, "_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": "tomoakin", "_selfowned": true, "_usedby": 25, "_updates": [], "_tags": [], "_stars": 66, "_contributors": [ { "user": "eddelbuettel", "count": 118, "uuid": 673121 }, { "user": "tomoakin", "count": 33, "uuid": 363232 }, { "user": "kalibera", "count": 1, "uuid": 1734520 } ], "_userbio": { "uuid": 363232, "type": "user", "name": "tomoakin" }, "_downloads": { "count": 35323, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RPostgreSQL" }, "_mentions": 8, "_devurl": "https://github.com/tomoakin/rpostgresql", "_searchresults": 4960, "_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/readme.html", "extra/readme.md", "extra/RPostgreSQL.html", "manual.pdf" ], "_homeurl": "https://github.com/tomoakin/rpostgresql", "_realowner": "tomoakin", "_cranurl": true, "_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" ] } ], "_readme": "https://github.com/tomoakin/rpostgresql/raw/HEAD/README.md", "_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": 11.841234443734518, "_indexed": true, "_nocasepkg": "rpostgresql", "_universes": [ "tomoakin" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.7-8", "date": "2026-06-01T06:50:38.000Z", "distro": "noble", "arch": "aarch64", "commit": "e8a32401d13549f8b1ffc8bc78ca572891495008", "fileid": "5aed0a96e3e940a3783a41c68d6f2f2d0bcd96af4bb0fb3cf607fc4c399e6ae8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555" }, { "r": "4.7.0", "os": "linux", "version": "0.7-8", "date": "2026-06-01T06:50:40.000Z", "distro": "noble", "arch": "x86_64", "commit": "e8a32401d13549f8b1ffc8bc78ca572891495008", "fileid": "f0b7477f81b918cba49a1d34f477d36818031d4a8c8560ef6a2afe805c36c275", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555" }, { "r": "4.6.0", "os": "linux", "version": "0.7-8", "date": "2026-06-01T06:50:34.000Z", "distro": "noble", "arch": "aarch64", "commit": "e8a32401d13549f8b1ffc8bc78ca572891495008", "fileid": "6f9db5d8485efc995783ad18f965a541e5a4ff3ddff1bcc8f9c09a73e948de2f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555" }, { "r": "4.6.0", "os": "linux", "version": "0.7-8", "date": "2026-06-01T06:50:39.000Z", "distro": "noble", "arch": "x86_64", "commit": "e8a32401d13549f8b1ffc8bc78ca572891495008", "fileid": "dd6fb90e9fb871366e9e2fcfb53930a0224650568c183e3f29020eb934302c81", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555" }, { "r": "4.5.3", "os": "mac", "version": "0.7-8", "date": "2026-06-01T06:53:49.000Z", "arch": "x86_64", "commit": "e8a32401d13549f8b1ffc8bc78ca572891495008", "fileid": "dc88a96e0721e41c54f03b78cf502c599325e1b8b375522f5c6fcb18b42e9654", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555" }, { "r": "4.6.0", "os": "mac", "version": "0.7-8", "date": "2026-06-01T06:54:49.000Z", "arch": "aarch64", "commit": "e8a32401d13549f8b1ffc8bc78ca572891495008", "fileid": "971e6e3177975b664a4569a1200af5e1d88e9914eb4e89af74da1f4e20d31d83", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555" }, { "r": "4.6.0", "os": "mac", "version": "0.7-8", "date": "2026-06-01T06:55:43.000Z", "arch": "x86_64", "commit": "e8a32401d13549f8b1ffc8bc78ca572891495008", "fileid": "5380db6e7bdac815a3644f6e75e3e0da8f2366e34fef01beb9343ce89a59d5aa", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555" }, { "r": "4.7.0", "os": "win", "version": "0.7-8", "date": "2026-06-01T06:50:19.000Z", "arch": "x86_64", "commit": "e8a32401d13549f8b1ffc8bc78ca572891495008", "fileid": "12c27248a09c7d3e4291cd96532da5c47066dd7d02336ad7be0103523d16bc01", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555" }, { "r": "4.5.3", "os": "win", "version": "0.7-8", "date": "2026-06-01T06:50:07.000Z", "arch": "x86_64", "commit": "e8a32401d13549f8b1ffc8bc78ca572891495008", "fileid": "44fe9d556d200766f745dfb47fd34b0a595e369d8a45e0e456f1ccf524eb0ee9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555" }, { "r": "4.6.0", "os": "win", "version": "0.7-8", "date": "2026-06-01T06:50:15.000Z", "arch": "x86_64", "commit": "e8a32401d13549f8b1ffc8bc78ca572891495008", "fileid": "add49c520ccb5d44a53fa625784967a98161fda2aae2518f42c8db2e649a81f5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tomoakin/actions/runs/26739606555" } ] }