{
  "_id": "6a3780bb3efcd9bda4416f0f",
  "Package": "RPostgres",
  "Title": "C++ Interface to PostgreSQL",
  "Version": "1.4.10.9010",
  "Date": "2026-06-21",
  "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",
  "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.0.0.9000",
  "Config/pak/sysreqs": "libpq-dev",
  "Repository": "https://r-dbi.r-universe.dev",
  "Date/Publication": "2026-06-21 05:28:42 UTC",
  "RemoteUrl": "https://github.com/r-dbi/rpostgres",
  "RemoteRef": "HEAD",
  "RemoteSha": "849cbf727f857d484bb2efad8840740cacb33310",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-06-21 06:02:24 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>",
  "MD5sum": "39de1d68f2a2916aa28e3729fc212b46",
  "_user": "r-dbi",
  "_type": "src",
  "_file": "RPostgres_1.4.10.9010.tar.gz",
  "_fileid": "ca723a6afe4b00a22016c94272cd7704e4e82223079ea3afd68eb538f0da886b",
  "_filesize": 1572087,
  "_sha256": "ca723a6afe4b00a22016c94272cd7704e4e82223079ea3afd68eb538f0da886b",
  "_created": "2026-06-21T06:02:24.000Z",
  "_published": "2026-06-21T06:12:11.282Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 82546069601,
      "time": 203,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7772425143"
    },
    {
      "job": 82546069603,
      "time": 171,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7772421678"
    },
    {
      "job": 82546069602,
      "time": 172,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7772421966"
    },
    {
      "job": 82546069599,
      "time": 158,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7772420176"
    },
    {
      "job": 82546069596,
      "time": 103,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7772414381"
    },
    {
      "job": 82546069608,
      "time": 243,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7772429085"
    },
    {
      "job": 82546069604,
      "time": 104,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7772414598"
    },
    {
      "job": 82546069606,
      "time": 246,
      "config": "macos-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7772429433"
    },
    {
      "job": 82545839741,
      "time": 225,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7772402363"
    },
    {
      "job": 82546069610,
      "time": 133,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "FAIL",
      "artifact": ""
    },
    {
      "job": 82546069593,
      "time": 538,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7772459736"
    },
    {
      "job": 82546069595,
      "time": 448,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7772450415"
    },
    {
      "job": 82546069600,
      "time": 463,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7772452005"
    }
  ],
  "_buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/r-dbi/rpostgres",
  "_commit": {
    "id": "849cbf727f857d484bb2efad8840740cacb33310",
    "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.9010 (#584)\n\nCo-authored-by: krlmlr <krlmlr@users.noreply.github.com>",
    "time": 1782019722
  },
  "_maintainer": {
    "name": "Kirill Müller",
    "email": "kirill@cynkra.com",
    "login": "krlmlr",
    "orcid": "0000-0002-1416-3412",
    "description": "Away from most OSS work until September 2026.",
    "uuid": 1741643
  },
  "_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": true,
  "_usedby": 41,
  "_updates": [
    {
      "week": "2025-31",
      "n": 2
    },
    {
      "week": "2025-32",
      "n": 2
    },
    {
      "week": "2025-36",
      "n": 4
    },
    {
      "week": "2025-37",
      "n": 4
    },
    {
      "week": "2025-39",
      "n": 3
    },
    {
      "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
    }
  ],
  "_tags": [
    {
      "name": "v1.4.7.9903",
      "date": "2025-08-01"
    },
    {
      "name": "v1.4.7.9904",
      "date": "2025-08-05"
    },
    {
      "name": "v1.4.7.9905",
      "date": "2025-09-05"
    },
    {
      "name": "v1.4.7.9906",
      "date": "2025-09-06"
    },
    {
      "name": "v1.4.8.9000",
      "date": "2025-09-14"
    },
    {
      "name": "v1.4.8.9001",
      "date": "2025-09-23"
    },
    {
      "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"
    }
  ],
  "_topics": [
    "database",
    "postgres",
    "postgresql",
    "cpp"
  ],
  "_stars": 339,
  "_contributors": [
    {
      "user": "krlmlr",
      "count": 1344,
      "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": "ateucher",
      "count": 2,
      "uuid": 2816635
    },
    {
      "user": "baderstine",
      "count": 2,
      "uuid": 2738299
    },
    {
      "user": "copilot",
      "count": 2,
      "uuid": 198982749
    },
    {
      "user": "jimhester",
      "count": 2,
      "uuid": 205275
    },
    {
      "user": "robertzk",
      "count": 2,
      "uuid": 1638492
    },
    {
      "user": "gatscha-trafficon",
      "count": 2,
      "uuid": 255119642
    },
    {
      "user": "troels",
      "count": 2,
      "uuid": 3203
    },
    {
      "user": "harvey131",
      "count": 2,
      "uuid": 26120526
    },
    {
      "user": "karawoo",
      "count": 2,
      "uuid": 4452678
    },
    {
      "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": 5695665,
    "type": "organization",
    "name": "r-dbi",
    "followers": 104,
    "description": "R + databases"
  },
  "_downloads": {
    "count": 55899,
    "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": 3584,
  "_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/RPostgres.html",
    "LICENSE",
    "manual.pdf"
  ],
  "_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": "16.14-0ubuntu0.24.04.1",
      "name": "postgresql",
      "homepage": "http://www.postgresql.org/",
      "description": "PostgreSQL C client library"
    },
    {
      "shlib": "libstdc++",
      "package": "libstdc++6",
      "source": "gcc",
      "version": "14.2.0-4ubuntu2~24.04.1",
      "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-02-15 18:52:51",
      "commits": 9
    }
  ],
  "_score": 15.490078573384439,
  "_indexed": true,
  "_nocasepkg": "rpostgres",
  "_universes": [
    "r-dbi",
    "krlmlr"
  ],
  "_previous": "1.4.10.9009",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:05:43.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "d712c376b95fae7bb4af615dcee3913f96903d404ddd55388769bede288eada7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:05:02.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "f27be01335bd4e0e26e9ffe5d7b91605afdaf3f4023513d57528f51ea17d4430",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:05:12.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "6533cb253fdbf7529eeb42fcd3c57259160784b25912ebaf33c6808a282f0e82",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:04:50.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "d3b151dd31f6d2b722b2311cae7ece4728f2c81927f2cfb31dbbcba1aea781da",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:04:11.000Z",
      "arch": "aarch64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "e8a74d3a6b1905aa308a374291d3e4d4006e4398ee796a398fd04ab9a066457c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:05:42.000Z",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "7869ccf6f5428669716e183bf64da3049d9608a4674b556ac0866b2ecbe4df44",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:04:10.000Z",
      "arch": "aarch64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "154de6d4e73b6291f044a4b4b01bf9483ca6d5be5bf649a1a102c3959b50c444",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:05:38.000Z",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "35ba7846ff52c62569403b4e9220a5aa93617f9ab71eac8ce45c5aaa899a62c2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:04:30.000Z",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "566797c37cd93be202e4a8c9bf7084cee4d3c3693709f350a4705a3304ec4a52",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:03:59.000Z",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "dd7cf77d3d148fa034892feb3f4d23e0b2c3eae3d8bd794ac05e095429ffd842",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.4.10.9010",
      "date": "2026-06-21T06:04:04.000Z",
      "arch": "x86_64",
      "commit": "849cbf727f857d484bb2efad8840740cacb33310",
      "fileid": "8dc2ce168da283d711dad17768feb8a92780c4b51d28b92470f98c14c72a0660",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/27895345939"
    }
  ]
}