{
  "_id": "6adc51b3077e75fa285b06f4",
  "Package": "RPostgres",
  "Title": "C++ Interface to PostgreSQL",
  "Version": "1.4.10.9020",
  "Date": "2026-10-11",
  "Authors@R": "c(\nperson(\"Hadley\", \"Wickham\", role = \"aut\"),\nperson(\"Jeroen\", \"Ooms\", role = \"aut\"),\nperson(\"Kirill\", \"Müller\", , \"kirill@cynkra.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-1416-3412\")),\nperson(\"RStudio\", role = \"cph\"),\nperson(\"R Consortium\", role = \"fnd\"),\nperson(\"Tomoaki\", \"Nishiyama\", role = \"ctb\",\ncomment = \"Code for encoding vectors into strings derived from RPostgreSQL\")\n)",
  "Description": "Fully DBI-compliant C++-backed interface to PostgreSQL\n<https://www.postgresql.org/>, an open-source relational\ndatabase.",
  "License": "MIT + file LICENSE",
  "URL": "https://rpostgres.r-dbi.org, https://github.com/r-dbi/RPostgres",
  "BugReports": "https://github.com/r-dbi/RPostgres/issues",
  "Config/Needs/website": "r-dbi/dbitemplate",
  "VignetteBuilder": "knitr",
  "Config/Needs/build": "decor",
  "Config/autostyle/scope": "line_breaks",
  "Config/autostyle/strict": "false",
  "Config/testthat/edition": "3",
  "Config/gha/filter": "os != \"windows-11-arm\"",
  "Config/comment/gha/filter": "No PostgreSQL server exists for ARM64\nWindows, and the DBItest suite needs a live one -- it connects\nin tests/testthat/helper-DBItest.R and has no path that skips\nwhen the server is absent. ankane/setup-postgres gives up on\nthat runner in about a second. Drop this filter once PostgreSQL\npublishes an ARM64 Windows server.",
  "Encoding": "UTF-8",
  "LazyLoad": "true",
  "Roxygen": "list(markdown = TRUE)",
  "SystemRequirements": "libpq >= 9.0: libpq-dev (deb) or postgresql-devel\n(rpm)",
  "Collate": "'PqDriver.R' 'PqConnection.R' 'PqResult.R' 'RPostgres-pkg.R'\n'Redshift.R' 'cpp11.R' 'dbAppendTable_PqConnection.R'\n'dbBegin_PqConnection.R' 'dbBind_PqResult.R'\n'dbClearResult_PqResult.R' 'dbColumnInfo_PqResult.R'\n'dbCommit_PqConnection.R' 'dbConnect_PqDriver.R'\n'dbConnect_RedshiftDriver.R' 'dbDataType_PqConnection.R'\n'dbDataType_PqDriver.R' 'dbDisconnect_PqConnection.R'\n'dbExistsTable_PqConnection_Id.R'\n'dbExistsTable_PqConnection_character.R' 'dbFetch_PqResult.R'\n'dbGetInfo_PqConnection.R' 'dbGetInfo_PqDriver.R'\n'dbGetRowCount_PqResult.R' 'dbGetRowsAffected_PqResult.R'\n'dbGetStatement_PqResult.R' 'dbHasCompleted_PqResult.R'\n'dbIsValid_PqConnection.R' 'dbIsValid_PqDriver.R'\n'dbIsValid_PqResult.R' 'dbListFields_PqConnection_Id.R'\n'dbListFields_PqConnection_character.R'\n'dbListObjects_PqConnection_ANY.R'\n'dbListTables_PqConnection.R'\n'dbQuoteIdentifier_PqConnection_Id.R'\n'dbQuoteIdentifier_PqConnection_SQL.R'\n'dbQuoteIdentifier_PqConnection_character.R'\n'dbQuoteLiteral_PqConnection.R'\n'dbQuoteString_PqConnection_SQL.R'\n'dbQuoteString_PqConnection_character.R'\n'dbReadTable_PqConnection_character.R'\n'dbRemoveTable_PqConnection_character.R'\n'dbRollback_PqConnection.R' 'dbSendQuery_PqConnection.R'\n'dbUnloadDriver_PqDriver.R'\n'dbUnquoteIdentifier_PqConnection_SQL.R'\n'dbWriteTable_PqConnection_character_data.frame.R' 'default.R'\n'export.R' 'quote.R' 'show_PqConnection.R'\n'sqlData_PqConnection.R' 'tables.R' 'transactions.R' 'utils.R'",
  "Config/roxygen2/version": "8.1.1.9000",
  "Config/pak/sysreqs": "libpq-dev",
  "Repository": "https://ar-puuk.r-universe.dev",
  "Date/Publication": "2026-10-11 00:38:28 UTC",
  "RemoteUrl": "https://github.com/r-dbi/RPostgres",
  "RemoteRef": "HEAD",
  "RemoteSha": "4055eb1021282550d89697bce2f28f8dc616d5d2",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-10-24 06:14:01 UTC",
    "User": "root"
  },
  "Author": "Hadley Wickham [aut],\nJeroen Ooms [aut],\nKirill Müller [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-1416-3412>),\nRStudio [cph],\nR Consortium [fnd],\nTomoaki Nishiyama [ctb] (Code for encoding vectors into strings derived\nfrom RPostgreSQL)",
  "Maintainer": "Kirill Müller <kirill@cynkra.com>",
  "_user": "ar-puuk",
  "_type": "src",
  "_file": "RPostgres_1.4.10.9020.tar.gz",
  "_fileid": "https://r2.ropensci.org/00e373b8f273fed598d1ad71022213d707b5e03c15826990b636c660b7a49a44",
  "_filesize": 1567239,
  "_sha256": "00e373b8f273fed598d1ad71022213d707b5e03c15826990b636c660b7a49a44",
  "_expires": "2027-02-01T06:35:29.000Z",
  "_created": "2026-10-24T06:14:01.000Z",
  "_published": "2026-10-24T06:35:31.040Z",
  "_upstream": "https://github.com/r-dbi/RPostgres",
  "_status": "success",
  "_maintainer": {
    "name": "Kirill Müller",
    "email": "kirill@cynkra.com",
    "login": "krlmlr",
    "orcid": "0000-0002-1416-3412",
    "description": "",
    "uuid": 1741643
  },
  "_jobs": [
    {
      "job": 120799484597,
      "time": 128,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12550462581"
    },
    {
      "job": 120799484678,
      "time": 181,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12550901134"
    },
    {
      "job": 120799484615,
      "time": 117,
      "config": "linux-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12550865440"
    },
    {
      "job": 120799484599,
      "time": 140,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12550404092"
    },
    {
      "job": 120799484586,
      "time": 176,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12550708945"
    },
    {
      "job": 120799484656,
      "time": 239,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12550767341"
    },
    {
      "job": 120799484602,
      "time": 142,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12550699049"
    },
    {
      "job": 120799484611,
      "time": 224,
      "config": "macos-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12551605206"
    },
    {
      "job": 120798655447,
      "time": 244,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12551010384"
    },
    {
      "job": 120799484583,
      "time": 142,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "FAIL",
      "artifact": ""
    },
    {
      "job": 120799484634,
      "time": 536,
      "config": "windows-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12551335019"
    },
    {
      "job": 120799484607,
      "time": 425,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12550856644"
    },
    {
      "job": 120799484668,
      "time": 457,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12550970735"
    },
    {
      "job": 120799484621,
      "time": 526,
      "config": "windows-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12551200701"
    },
    {
      "job": 120799484605,
      "time": 446,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12550896661"
    }
  ],
  "_buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264",
  "_commit": {
    "id": "4055eb1021282550d89697bce2f28f8dc616d5d2",
    "author": "github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "fledge: Bump version to 1.4.10.9020 (#618)\n\nCo-authored-by: krlmlr <krlmlr@users.noreply.github.com>",
    "time": 1791679108
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.1.0",
      "role": "Depends"
    },
    {
      "package": "cpp11",
      "role": "LinkingTo"
    },
    {
      "package": "bit64",
      "role": "Imports"
    },
    {
      "package": "blob",
      "version": ">= 1.2.0",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 1.2.0",
      "role": "Imports"
    },
    {
      "package": "hms",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "withr",
      "role": "Imports"
    },
    {
      "package": "callr",
      "role": "Suggests"
    },
    {
      "package": "covr",
      "role": "Suggests"
    },
    {
      "package": "DBItest",
      "version": ">= 1.7.3",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rlang",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    }
  ],
  "_owner": "r-dbi",
  "_selfowned": false,
  "_usedby": 42,
  "_updates": [
    {
      "week": "2025-45",
      "n": 3
    },
    {
      "week": "2025-46",
      "n": 4
    },
    {
      "week": "2025-47",
      "n": 1
    },
    {
      "week": "2026-03",
      "n": 3
    },
    {
      "week": "2026-05",
      "n": 3
    },
    {
      "week": "2026-06",
      "n": 6
    },
    {
      "week": "2026-07",
      "n": 4
    },
    {
      "week": "2026-08",
      "n": 1
    },
    {
      "week": "2026-10",
      "n": 2
    },
    {
      "week": "2026-11",
      "n": 5
    },
    {
      "week": "2026-12",
      "n": 2
    },
    {
      "week": "2026-19",
      "n": 9
    },
    {
      "week": "2026-20",
      "n": 8
    },
    {
      "week": "2026-21",
      "n": 3
    },
    {
      "week": "2026-25",
      "n": 2
    },
    {
      "week": "2026-30",
      "n": 5
    },
    {
      "week": "2026-31",
      "n": 6
    },
    {
      "week": "2026-32",
      "n": 14
    },
    {
      "week": "2026-36",
      "n": 2
    },
    {
      "week": "2026-37",
      "n": 15
    },
    {
      "week": "2026-38",
      "n": 4
    },
    {
      "week": "2026-39",
      "n": 11
    },
    {
      "week": "2026-40",
      "n": 1
    },
    {
      "week": "2026-41",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v1.4.8.9002",
      "date": "2025-11-08"
    },
    {
      "name": "v1.4.8.9003",
      "date": "2025-11-11"
    },
    {
      "name": "v1.4.8.9004",
      "date": "2025-11-12"
    },
    {
      "name": "v1.4.8.9005",
      "date": "2025-11-17"
    },
    {
      "name": "v1.4.8.9006",
      "date": "2026-01-14"
    },
    {
      "name": "v1.4.8.9007",
      "date": "2026-02-02"
    },
    {
      "name": "v1.4.8.9008",
      "date": "2026-02-05"
    },
    {
      "name": "v1.4.9",
      "date": "2026-02-05"
    },
    {
      "name": "v1.4.9.9000",
      "date": "2026-02-06"
    },
    {
      "name": "v1.4.9.9001",
      "date": "2026-02-11"
    },
    {
      "name": "v1.4.10",
      "date": "2026-02-15"
    },
    {
      "name": "v1.4.10.9000",
      "date": "2026-02-16"
    },
    {
      "name": "v1.4.10.9001",
      "date": "2026-03-08"
    },
    {
      "name": "v1.4.10.9002",
      "date": "2026-03-13"
    },
    {
      "name": "v1.4.10.9003",
      "date": "2026-03-14"
    },
    {
      "name": "v1.4.10.9004",
      "date": "2026-03-22"
    },
    {
      "name": "v1.4.10.9005",
      "date": "2026-05-05"
    },
    {
      "name": "v1.4.10.9006",
      "date": "2026-05-06"
    },
    {
      "name": "v1.4.10.9007",
      "date": "2026-05-13"
    },
    {
      "name": "v1.4.10.9008",
      "date": "2026-05-16"
    },
    {
      "name": "v1.4.10.9009",
      "date": "2026-05-24"
    },
    {
      "name": "v1.4.10.9010",
      "date": "2026-06-21"
    },
    {
      "name": "v1.4.10.9011",
      "date": "2026-07-28"
    },
    {
      "name": "v1.4.10.9012",
      "date": "2026-08-05"
    },
    {
      "name": "v1.4.10.9013",
      "date": "2026-08-06"
    },
    {
      "name": "v1.4.10.9014",
      "date": "2026-08-08"
    },
    {
      "name": "v1.4.10.9015",
      "date": "2026-09-05"
    },
    {
      "name": "v1.4.10.9016",
      "date": "2026-09-13"
    },
    {
      "name": "v1.4.10.9017",
      "date": "2026-09-13"
    },
    {
      "name": "v1.4.10.9018",
      "date": "2026-09-15"
    },
    {
      "name": "v1.4.10.9019",
      "date": "2026-09-27"
    },
    {
      "name": "v1.4.10.9020",
      "date": "2026-10-11"
    }
  ],
  "_topics": [
    "database",
    "postgres",
    "postgresql",
    "cpp"
  ],
  "_stars": 344,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 1394,
      "uuid": 1741643
    },
    {
      "user": "hadley",
      "count": 113,
      "uuid": 4196
    },
    {
      "user": "jeroen",
      "count": 54,
      "uuid": 216319
    },
    {
      "user": "antonov548",
      "count": 51,
      "uuid": 22891541
    },
    {
      "user": "dpprdan",
      "count": 25,
      "uuid": 1423562
    },
    {
      "user": "thrasibule",
      "count": 23,
      "uuid": 494248
    },
    {
      "user": "zozlak",
      "count": 16,
      "uuid": 6503177
    },
    {
      "user": "jackstat",
      "count": 14,
      "uuid": 2999465
    },
    {
      "user": "lentinj",
      "count": 10,
      "uuid": 586911
    },
    {
      "user": "tschiefer",
      "count": 9,
      "uuid": 11596155
    },
    {
      "user": "indrajeetpatil",
      "count": 8,
      "uuid": 11330453
    },
    {
      "user": "jschoenbachler",
      "count": 7,
      "uuid": 15148457
    },
    {
      "user": "etiennebr",
      "count": 7,
      "uuid": 393576
    },
    {
      "user": "pachadotdev",
      "count": 7,
      "uuid": 10091065
    },
    {
      "user": "jakob-r",
      "count": 5,
      "uuid": 1888623
    },
    {
      "user": "galachad",
      "count": 4,
      "uuid": 4296390
    },
    {
      "user": "mmuurr",
      "count": 3,
      "uuid": 5702538
    },
    {
      "user": "maelle",
      "count": 3,
      "uuid": 8360597
    },
    {
      "user": "jaredk-porch",
      "count": 3,
      "uuid": 12500708
    },
    {
      "user": "web-flow",
      "count": 3,
      "uuid": 19864447
    },
    {
      "user": "claude",
      "count": 3,
      "uuid": 81847
    },
    {
      "user": "karawoo",
      "count": 2,
      "uuid": 4452678
    },
    {
      "user": "harvey131",
      "count": 2,
      "uuid": 26120526
    },
    {
      "user": "troels",
      "count": 2,
      "uuid": 3203
    },
    {
      "user": "gatscha-trafficon",
      "count": 2,
      "uuid": 255119642
    },
    {
      "user": "robertzk",
      "count": 2,
      "uuid": 1638492
    },
    {
      "user": "jimhester",
      "count": 2,
      "uuid": 205275
    },
    {
      "user": "copilot",
      "count": 2,
      "uuid": 198982749
    },
    {
      "user": "baderstine",
      "count": 2,
      "uuid": 2738299
    },
    {
      "user": "ateucher",
      "count": 2,
      "uuid": 2816635
    },
    {
      "user": "oz-r",
      "count": 1,
      "uuid": 17580114
    },
    {
      "user": "toppyy",
      "count": 1,
      "uuid": 43851547
    },
    {
      "user": "hrbrmstr",
      "count": 1,
      "uuid": 509878
    },
    {
      "user": "rstammer",
      "count": 1,
      "uuid": 3685123
    },
    {
      "user": "pedrobtz",
      "count": 1,
      "uuid": 2864346
    },
    {
      "user": "junduck",
      "count": 1,
      "uuid": 2279688
    },
    {
      "user": "daattali",
      "count": 1,
      "uuid": 952340
    },
    {
      "user": "claytonjy",
      "count": 1,
      "uuid": 5169330
    },
    {
      "user": "altons",
      "count": 1,
      "uuid": 244547
    }
  ],
  "_userbio": {
    "uuid": 97474785,
    "type": "user",
    "name": "Pukar Bhandari",
    "followers": 28,
    "description": "I am a Data Scientist at Wasatch Front Regional Council and I am interested in Geospatial Data Analytics, particularly in land use and transportation."
  },
  "_downloads": {
    "count": 51069,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RPostgres"
  },
  "_mentions": 1,
  "_devurl": "https://github.com/r-dbi/rpostgres",
  "_pkgdown": "https://rpostgres.r-dbi.org",
  "_searchresults": 3936,
  "_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/readme.html",
    "extra/readme.md",
    "extra/RPostgres.html",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/r-dbi/rpostgres",
  "_realowner": "r-dbi",
  "_cranurl": true,
  "_releases": [
    {
      "version": "1.0-3",
      "date": "2017-12-06"
    },
    {
      "version": "1.0-4",
      "date": "2017-12-20"
    },
    {
      "version": "1.1.0",
      "date": "2018-04-06"
    },
    {
      "version": "1.1.1",
      "date": "2018-05-06"
    },
    {
      "version": "1.1.2",
      "date": "2019-12-03"
    },
    {
      "version": "1.1.3",
      "date": "2019-12-07"
    },
    {
      "version": "1.2.0",
      "date": "2019-12-18"
    },
    {
      "version": "1.2.1",
      "date": "2020-09-28"
    },
    {
      "version": "1.3.0",
      "date": "2021-01-07"
    },
    {
      "version": "1.3.1",
      "date": "2021-01-19"
    },
    {
      "version": "1.3.2",
      "date": "2021-04-12"
    },
    {
      "version": "1.3.3",
      "date": "2021-07-05"
    },
    {
      "version": "1.4.0",
      "date": "2021-09-26"
    },
    {
      "version": "1.4.1",
      "date": "2021-09-27"
    },
    {
      "version": "1.4.2",
      "date": "2021-12-05"
    },
    {
      "version": "1.4.3",
      "date": "2021-12-20"
    },
    {
      "version": "1.4.4",
      "date": "2022-05-02"
    },
    {
      "version": "1.4.5",
      "date": "2023-01-20"
    },
    {
      "version": "1.4.6",
      "date": "2023-10-22"
    },
    {
      "version": "1.4.7",
      "date": "2024-05-27"
    },
    {
      "version": "1.4.8",
      "date": "2025-02-25"
    },
    {
      "version": "1.4.9",
      "date": "2026-02-06"
    },
    {
      "version": "1.4.10",
      "date": "2026-02-16"
    }
  ],
  "_exports": [
    "dbAppendTable",
    "dbBegin",
    "dbBind",
    "dbCanConnect",
    "dbClearResult",
    "dbColumnInfo",
    "dbCommit",
    "dbConnect",
    "dbCreateTable",
    "dbDataType",
    "dbDisconnect",
    "dbDriver",
    "dbExecute",
    "dbExistsTable",
    "dbFetch",
    "dbGetInfo",
    "dbGetQuery",
    "dbGetRowCount",
    "dbGetRowsAffected",
    "dbGetStatement",
    "dbHasCompleted",
    "dbIsReadOnly",
    "dbIsValid",
    "dbListFields",
    "dbListObjects",
    "dbListResults",
    "dbListTables",
    "dbQuoteIdentifier",
    "dbQuoteLiteral",
    "dbQuoteString",
    "dbReadTable",
    "dbRemoveTable",
    "dbRollback",
    "dbSendQuery",
    "dbSendStatement",
    "dbUnloadDriver",
    "dbUnquoteIdentifier",
    "dbWithTransaction",
    "dbWriteTable",
    "Id",
    "Postgres",
    "postgresDefault",
    "postgresExportLargeObject",
    "postgresHasDefault",
    "postgresImportLargeObject",
    "postgresIsTransacting",
    "postgresWaitForNotify",
    "Redshift",
    "show",
    "sqlData"
  ],
  "_help": [
    {
      "page": "RPostgres-package",
      "title": "RPostgres: C++ Interface to PostgreSQL",
      "topics": [
        "RPostgres-package",
        "RPostgres"
      ]
    },
    {
      "page": "Postgres",
      "title": "Postgres driver",
      "topics": [
        "dbConnect,PqDriver-method",
        "dbConnect_PqDriver",
        "dbDisconnect,PqConnection-method",
        "dbDisconnect_PqConnection",
        "Postgres"
      ]
    },
    {
      "page": "postgres-query",
      "title": "Execute a SQL statement on a database connection",
      "topics": [
        "dbBind,PqResult-method",
        "dbBind_PqResult",
        "dbClearResult,PqResult-method",
        "dbClearResult_PqResult",
        "dbFetch,PqResult-method",
        "dbFetch_PqResult",
        "dbHasCompleted,PqResult-method",
        "dbHasCompleted_PqResult",
        "dbSendQuery,PqConnection-method",
        "dbSendQuery_PqConnection",
        "postgres-query"
      ]
    },
    {
      "page": "postgres-tables",
      "title": "Convenience functions for reading/writing DBMS tables",
      "topics": [
        "dbAppendTable,PqConnection-method",
        "dbAppendTable_PqConnection",
        "dbExistsTable,PqConnection,character-method",
        "dbExistsTable,PqConnection,Id-method",
        "dbExistsTable_PqConnection_character",
        "dbExistsTable_PqConnection_Id",
        "dbListFields,PqConnection,character-method",
        "dbListFields,PqConnection,Id-method",
        "dbListFields_PqConnection_character",
        "dbListFields_PqConnection_Id",
        "dbListObjects,PqConnection-method",
        "dbListObjects_PqConnection_ANY",
        "dbListTables,PqConnection-method",
        "dbListTables_PqConnection",
        "dbReadTable,PqConnection,character-method",
        "dbReadTable_PqConnection_character",
        "dbRemoveTable,PqConnection,character-method",
        "dbRemoveTable_PqConnection_character",
        "dbWriteTable,PqConnection,character,data.frame-method",
        "dbWriteTable_PqConnection_character_data.frame",
        "postgres-tables",
        "sqlData,PqConnection-method",
        "sqlData_PqConnection"
      ]
    },
    {
      "page": "postgres-transactions",
      "title": "Transaction management.",
      "topics": [
        "dbBegin,PqConnection-method",
        "dbBegin_PqConnection",
        "dbCommit,PqConnection-method",
        "dbCommit_PqConnection",
        "dbRollback,PqConnection-method",
        "dbRollback_PqConnection",
        "postgres-transactions"
      ]
    },
    {
      "page": "postgresExportLargeObject",
      "title": "Exports a large object to file",
      "topics": [
        "postgresExportLargeObject"
      ]
    },
    {
      "page": "postgresHasDefault",
      "title": "Check if default database is available.",
      "topics": [
        "postgresDefault",
        "postgresHasDefault"
      ]
    },
    {
      "page": "postgresImportLargeObject",
      "title": "Imports a large object from file",
      "topics": [
        "postgresImportLargeObject"
      ]
    },
    {
      "page": "postgresIsTransacting",
      "title": "Return whether a transaction is ongoing",
      "topics": [
        "postgresIsTransacting"
      ]
    },
    {
      "page": "postgresWaitForNotify",
      "title": "Wait for and return any notifications that return within timeout",
      "topics": [
        "postgresWaitForNotify"
      ]
    },
    {
      "page": "quote",
      "title": "Quote postgres strings, identifiers, and literals",
      "topics": [
        "dbQuoteIdentifier,PqConnection,character-method",
        "dbQuoteIdentifier,PqConnection,Id-method",
        "dbQuoteIdentifier,PqConnection,SQL-method",
        "dbQuoteIdentifier_PqConnection_character",
        "dbQuoteIdentifier_PqConnection_Id",
        "dbQuoteIdentifier_PqConnection_SQL",
        "dbQuoteLiteral,PqConnection-method",
        "dbQuoteLiteral_PqConnection",
        "dbQuoteString,PqConnection,character-method",
        "dbQuoteString,PqConnection,SQL-method",
        "dbQuoteString_PqConnection_character",
        "dbQuoteString_PqConnection_SQL",
        "dbUnquoteIdentifier,PqConnection,SQL-method",
        "dbUnquoteIdentifier_PqConnection_SQL",
        "quote"
      ]
    },
    {
      "page": "Redshift",
      "title": "Redshift driver/connection",
      "topics": [
        "dbConnect,RedshiftDriver-method",
        "dbConnect_RedshiftDriver",
        "Redshift",
        "RedshiftConnection-class",
        "RedshiftDriver-class"
      ]
    }
  ],
  "_readme": "https://github.com/r-dbi/RPostgres/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cli",
    "cpp11",
    "DBI",
    "generics",
    "glue",
    "hms",
    "lifecycle",
    "lubridate",
    "pkgconfig",
    "rlang",
    "timechange",
    "vctrs",
    "withr"
  ],
  "_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"
    },
    {
      "shlib": "libstdc++",
      "package": "libstdc++6",
      "source": "gcc",
      "version": "16-20260322-1ubuntu1",
      "name": "c++",
      "homepage": "http://gcc.gnu.org/",
      "description": "GNU Standard C++ Library v3"
    }
  ],
  "_vignettes": [
    {
      "source": "work-queue.Rmd",
      "filename": "work-queue.html",
      "title": "Implementing a Work Queue using RPostgres",
      "author": "Jamie Lentin",
      "engine": "knitr::rmarkdown",
      "headings": [
        "LISTEN / NOTIFY",
        "SKIP LOCKED",
        "Implementing our worker"
      ],
      "created": "2020-10-18 06:16:59",
      "modified": "2026-09-14 14:37:20",
      "commits": 10
    }
  ],
  "_score": 15.599106273979064,
  "_indexed": false,
  "_nocasepkg": "rpostgres",
  "_universes": [
    "ar-puuk"
  ],
  "_indexurl": "https://r-dbi.r-universe.dev/RPostgres",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:16:14.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/40f7b2c82ecb3f3656eede7b8a860e9f287784a3d3e149f82910e9a0d89e01aa",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:17:01.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/55ca30e0b4e1239b529fa518803b24acdc19678aafc53a44153bbf6a189bf660",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:16:09.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/cdc03e756a03dfbbf16eb97942f6f12c567ae334e550c4cce59bfd07aacf64b5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:16:30.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/5b3b7fd5d82e15cabcfd56d3ba1714b45fd0ef2bb210c0e1997d8f4c72a3e176",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:29:02.000Z",
      "arch": "aarch64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/4c5145a1ab612ef203e5ec253a09937fd4782bb2c8c64683222a4b33eeff2f44",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:33:32.000Z",
      "arch": "x86_64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/96832b83b8cf77c392c90f1d77dea4f691cb93053ee7bd3685075e8bf3a86d22",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:30:08.000Z",
      "arch": "aarch64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/a86674313bbf2db1cf8f01b697f490cd81ff30523a3842e1f88fed4babffad79",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:30:56.000Z",
      "arch": "x86_64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/f11d8a2a40f0597a61ed979bce6975aa63322caf6342f3aec75a28c49a619198",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:17:53.000Z",
      "arch": "aarch64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/dbc0a9b46a1b238cc773300bb3d51b09fb482eb73afe8d66e6dd11fc2394f85a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:15:34.000Z",
      "arch": "x86_64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/5dd2b16b3ec97f00bef2e8d5900cfdb10fa57116cb33f19fd49d3335d472bab5",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:15:59.000Z",
      "arch": "x86_64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/7d4a08e29a6931d9f8fc4532a81007e865bf951cc926b11fd22be0c91196a6d9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:17:42.000Z",
      "arch": "aarch64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/943f4b9c15ba8a19f4f5d2af436e234904a6471aad494c7de0ec82089daf9962",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.4.10.9020",
      "date": "2026-10-24T06:16:01.000Z",
      "arch": "x86_64",
      "commit": "4055eb1021282550d89697bce2f28f8dc616d5d2",
      "fileid": "https://r2.ropensci.org/52879e02c1f64b6be08643d1cd658398bd0db6eea1470192bb1c8dbc9f560066",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/ar-puuk/actions/runs/40069144264"
    }
  ]
}