This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/arrow-adbc.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 65c994d51 publish documentation
65c994d51 is described below
commit 65c994d51bd821be2f24f6c4f74b46064f2a5a80
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Oct 23 06:31:36 2025 +0000
publish documentation
---
main/_sources/python/recipe/postgresql.rst.txt | 5 ++
main/genindex.html | 66 ++++++++++++++--------
main/python/api/adbc_driver_postgresql.html | 7 ++-
main/python/recipe/index.html | 1 +
main/python/recipe/postgresql.html | 54 ++++++++++++++----
main/r/adbcbigquery/pkgdown.yml | 2 +-
main/r/adbcdrivermanager/pkgdown.yml | 2 +-
.../reference/adbc_connection_init.html | 4 +-
.../reference/adbc_database_init.html | 2 +-
.../reference/adbc_statement_init.html | 6 +-
main/r/adbcdrivermanager/search.json | 2 +-
main/r/adbcflightsql/pkgdown.yml | 2 +-
main/r/adbcpostgresql/pkgdown.yml | 2 +-
main/r/adbcsnowflake/pkgdown.yml | 2 +-
main/r/adbcsqlite/pkgdown.yml | 2 +-
main/searchindex.js | 2 +-
16 files changed, 111 insertions(+), 50 deletions(-)
diff --git a/main/_sources/python/recipe/postgresql.rst.txt
b/main/_sources/python/recipe/postgresql.rst.txt
index f1f885d02..279a1ef69 100644
--- a/main/_sources/python/recipe/postgresql.rst.txt
+++ b/main/_sources/python/recipe/postgresql.rst.txt
@@ -24,6 +24,11 @@ Authenticate with a username and password
.. recipe:: postgresql_authenticate.py
+Enable autocommit mode
+=======================
+
+.. recipe:: postgresql_autocommit.py
+
.. _recipe-postgresql-create-append:
Create/append to a table from an Arrow dataset
diff --git a/main/genindex.html b/main/genindex.html
index 52507a517..e91b7dd72 100644
--- a/main/genindex.html
+++ b/main/genindex.html
@@ -519,10 +519,10 @@
</li>
<li><a
href="python/api/adbc_driver_manager.html#adbc_driver_manager.dbapi.Connection.adbc_get_objects">adbc_get_objects()
(adbc_driver_manager.dbapi.Connection method)</a>
</li>
- </ul></td>
- <td style="width: 33%; vertical-align: top;"><ul>
<li><a
href="python/api/adbc_driver_manager.html#adbc_driver_manager.dbapi.Connection.adbc_get_table_schema">adbc_get_table_schema()
(adbc_driver_manager.dbapi.Connection method)</a>
</li>
+ </ul></td>
+ <td style="width: 33%; vertical-align: top;"><ul>
<li><a
href="python/api/adbc_driver_manager.html#adbc_driver_manager.dbapi.Connection.adbc_get_table_types">adbc_get_table_types()
(adbc_driver_manager.dbapi.Connection method)</a>
</li>
<li><a
href="python/api/adbc_driver_manager.html#adbc_driver_manager.dbapi.Cursor.adbc_ingest">adbc_ingest()
(adbc_driver_manager.dbapi.Cursor method)</a>
@@ -608,6 +608,13 @@
</li>
<li><a
href="python/api/adbc_driver_flightsql.html#adbc_driver_flightsql.DatabaseOptions.AUTHORIZATION_HEADER">AUTHORIZATION_HEADER
(adbc_driver_flightsql.DatabaseOptions attribute)</a>
</li>
+ <li>
+ autocommit (recipe)
+
+ <ul>
+ <li><a href="python/recipe/postgresql.html#index-1">PostgreSQL</a>
+</li>
+ </ul></li>
</ul></td>
</tr></table>
</section>
@@ -633,7 +640,7 @@
bind parameters (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-4">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-5">PostgreSQL</a>
</li>
</ul></li>
<li><a
href="python/api/adbc_driver_manager.html#adbc_driver_manager.AdbcStatement.bind">bind()
(adbc_driver_manager.AdbcStatement method)</a>
@@ -648,21 +655,21 @@
bulk append (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-2">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-3">PostgreSQL</a>
</li>
</ul></li>
<li>
bulk ingestion from PyArrow Dataset (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-1">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-2">PostgreSQL</a>
</li>
</ul></li>
<li>
bulk ingestion to temporary table (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-3">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-4">PostgreSQL</a>
</li>
</ul></li>
</ul></td>
@@ -760,7 +767,7 @@
connection pooling (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-9">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-10">PostgreSQL</a>
</li>
</ul></li>
<li><a
href="python/api/adbc_driver_flightsql.html#adbc_driver_flightsql.ConnectionOptions">ConnectionOptions
(class in adbc_driver_flightsql)</a>
@@ -939,14 +946,14 @@
get query result set schema (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-7">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-8">PostgreSQL</a>
</li>
</ul></li>
<li>
get table schema (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-6">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-7">PostgreSQL</a>
</li>
</ul></li>
<li><a
href="python/api/adbc_driver_manager.html#adbc_driver_manager.AdbcConnection.get_info">get_info()
(adbc_driver_manager.AdbcConnection method)</a>
@@ -1224,7 +1231,7 @@
pandas integration (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-10">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-11">PostgreSQL</a>
</li>
</ul></li>
<li><a
href="python/api/adbc_driver_manager.html#adbc_driver_manager.dbapi.paramstyle">paramstyle
(in module adbc_driver_manager.dbapi)</a>
@@ -1235,7 +1242,7 @@
polars integration (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-11">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-12">PostgreSQL</a>
</li>
</ul></li>
<li><a
href="python/api/adbc_driver_snowflake.html#adbc_driver_snowflake.DatabaseOptions.PORT">PORT
(adbc_driver_snowflake.DatabaseOptions attribute)</a>
@@ -1246,27 +1253,31 @@
<ul>
<li><a href="python/recipe/postgresql.html#index-0">authentication
(recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-4">bind parameters
(recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-1">autocommit
(recipe)</a>
+</li>
+ <li><a href="python/recipe/postgresql.html#index-5">bind parameters
(recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-2">bulk append
(recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-3">bulk append
(recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-1">bulk ingestion
from PyArrow Dataset (recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-2">bulk ingestion
from PyArrow Dataset (recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-3">bulk ingestion
to temporary table (recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-4">bulk ingestion
to temporary table (recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-9">connection
pooling (recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-10">connection
pooling (recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-7">get query result
set schema (recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-8">get query result
set schema (recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-6">get table schema
(recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-7">get table schema
(recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-10">pandas
integration (recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-11">pandas
integration (recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-11">polars
integration (recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-12">polars
integration (recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-8">query catalog
(recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-9">query catalog
(recipe)</a>
</li>
- <li><a href="python/recipe/postgresql.html#index-5">statement
options (recipe)</a>
+ <li><a href="python/recipe/postgresql.html#index-6">statement
options (recipe)</a>
+</li>
+ <li><a href="python/recipe/postgresql.html#index-1">transactions
(recipe)</a>
</li>
</ul></li>
</ul></td>
@@ -1304,7 +1315,7 @@
query catalog (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-8">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-9">PostgreSQL</a>
</li>
</ul></li>
</ul></td>
@@ -1408,7 +1419,7 @@
statement options (recipe)
<ul>
- <li><a href="python/recipe/postgresql.html#index-5">PostgreSQL</a>
+ <li><a href="python/recipe/postgresql.html#index-6">PostgreSQL</a>
</li>
</ul></li>
<li><a
href="python/api/adbc_driver_bigquery.html#adbc_driver_bigquery.StatementOptions">StatementOptions
(class in adbc_driver_bigquery)</a>
@@ -1490,6 +1501,13 @@
<li><a
href="python/api/adbc_driver_postgresql.html#adbc_driver_postgresql.ConnectionOptions.TRANSACTION_STATUS">TRANSACTION_STATUS
(adbc_driver_postgresql.ConnectionOptions attribute)</a>
</li>
<li>
+ transactions (recipe)
+
+ <ul>
+ <li><a href="python/recipe/postgresql.html#index-1">PostgreSQL</a>
+</li>
+ </ul></li>
+ <li>
type inference (recipe)
<ul>
diff --git a/main/python/api/adbc_driver_postgresql.html
b/main/python/api/adbc_driver_postgresql.html
index 998669aa0..323e94099 100644
--- a/main/python/api/adbc_driver_postgresql.html
+++ b/main/python/api/adbc_driver_postgresql.html
@@ -448,7 +448,7 @@ actual size may differ.</p>
<p>DBAPI 2.0-compatible facade for the ADBC libpq driver.</p>
<dl class="py function">
<dt class="sig sig-object py" id="adbc_driver_postgresql.dbapi.connect">
-<span class="sig-prename descclassname"><span
class="pre">adbc_driver_postgresql.dbapi.</span></span><span class="sig-name
descname"><span class="pre">connect</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">uri</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference external"
href="https://docs.python.org/3/library/stdtypes.html#str"; title="(in Python
v3.14)"><span class [...]
+<span class="sig-prename descclassname"><span
class="pre">adbc_driver_postgresql.dbapi.</span></span><span class="sig-name
descname"><span class="pre">connect</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">uri</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference external"
href="https://docs.python.org/3/library/stdtypes.html#str"; title="(in Python
v3.14)"><span class [...]
<dd><p>Connect to PostgreSQL via ADBC.</p>
<dl class="field-list simple">
<dt class="field-odd">Parameters<span class="colon">:</span></dt>
@@ -461,6 +461,11 @@ actual size may differ.</p>
a ‘database’ object shared between multiple ‘connection’
objects.)</p>
</dd>
+<dt><strong>autocommit</strong><span
class="classifier">bool</span></dt><dd><p>Enable autocommit mode. If True,
transactions are automatically
+committed after each statement. Defaults to False.</p>
+</dd>
+<dt><strong>**kwargs</strong></dt><dd><p>Additional keyword arguments passed
to the Connection constructor.</p>
+</dd>
</dl>
</dd>
</dl>
diff --git a/main/python/recipe/index.html b/main/python/recipe/index.html
index 51c7ab486..f8e5a081c 100644
--- a/main/python/recipe/index.html
+++ b/main/python/recipe/index.html
@@ -416,6 +416,7 @@ Python.</p>
</li>
<li class="toctree-l1"><a class="reference internal"
href="postgresql.html">PostgreSQL Recipes</a><ul>
<li class="toctree-l2"><a class="reference internal"
href="postgresql.html#authenticate-with-a-username-and-password">Authenticate
with a username and password</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="postgresql.html#enable-autocommit-mode">Enable autocommit mode</a></li>
<li class="toctree-l2"><a class="reference internal"
href="postgresql.html#create-append-to-a-table-from-an-arrow-dataset">Create/append
to a table from an Arrow dataset</a></li>
<li class="toctree-l2"><a class="reference internal"
href="postgresql.html#create-append-to-a-table-from-an-arrow-table">Create/append
to a table from an Arrow table</a></li>
<li class="toctree-l2"><a class="reference internal"
href="postgresql.html#create-append-to-a-temporary-table">Create/append to a
temporary table</a></li>
diff --git a/main/python/recipe/postgresql.html
b/main/python/recipe/postgresql.html
index 00b4f8814..0db56f8f3 100644
--- a/main/python/recipe/postgresql.html
+++ b/main/python/recipe/postgresql.html
@@ -430,9 +430,40 @@ for full details.</p>
</div>
</div>
</section>
+<section id="enable-autocommit-mode">
+<h2>Enable autocommit mode<a class="headerlink" href="#enable-autocommit-mode"
title="Link to this heading">¶</a></h2>
+<p id="index-1">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_autocommit.py";>postgresql_autocommit.py</a></p>
+<p>You can enable autocommit mode by passing the <code class="docutils literal
notranslate"><span class="pre">autocommit</span></code> parameter
+to the <code class="docutils literal notranslate"><span
class="pre">connect</span></code> function. When autocommit is enabled, each
statement
+is automatically committed without needing to call <code class="docutils
literal notranslate"><span class="pre">commit()</span></code> explicitly.
+This is useful for operations that cannot be run inside a transaction,
+or when you want each statement to be committed immediately.</p>
+<div class="highlight-python notranslate"><div
class="highlight"><pre><span></span><span class="linenos">27</span><span
class="kn">import</span><span class="w"> </span><span class="nn">os</span>
+<span class="linenos">28</span>
+<span class="linenos">29</span><span class="kn">import</span><span class="w">
</span><span class="nn">adbc_driver_postgresql.dbapi</span>
+<span class="linenos">30</span>
+<span class="linenos">31</span><span class="n">uri</span> <span
class="o">=</span> <span class="n">os</span><span class="o">.</span><span
class="n">environ</span><span class="p">[</span><span
class="s2">"ADBC_POSTGRESQL_TEST_URI"</span><span class="p">]</span>
+<span class="linenos">32</span>
+<span class="linenos">33</span><span class="c1"># Enable autocommit mode</span>
+<span class="linenos">34</span><span class="n">conn</span> <span
class="o">=</span> <span class="n">adbc_driver_postgresql</span><span
class="o">.</span><span class="n">dbapi</span><span class="o">.</span><span
class="n">connect</span><span class="p">(</span><span class="n">uri</span><span
class="p">,</span> <span class="n">autocommit</span><span
class="o">=</span><span class="kc">True</span><span class="p">)</span>
+<span class="linenos">35</span>
+<span class="linenos">36</span><span class="k">with</span> <span
class="n">conn</span><span class="o">.</span><span class="n">cursor</span><span
class="p">()</span> <span class="k">as</span> <span class="n">cur</span><span
class="p">:</span>
+<span class="linenos">37</span> <span class="c1"># In autocommit mode, this
statement is automatically committed</span>
+<span class="linenos">38</span> <span class="n">cur</span><span
class="o">.</span><span class="n">execute</span><span class="p">(</span><span
class="s2">"CREATE TEMP TABLE IF NOT EXISTS autocommit_test (id
INTEGER)"</span><span class="p">)</span>
+<span class="linenos">39</span> <span class="n">cur</span><span
class="o">.</span><span class="n">execute</span><span class="p">(</span><span
class="s2">"INSERT INTO autocommit_test VALUES (1)"</span><span
class="p">)</span>
+<span class="linenos">40</span>
+<span class="linenos">41</span><span class="c1"># Verify the data was
committed</span>
+<span class="linenos">42</span><span class="k">with</span> <span
class="n">conn</span><span class="o">.</span><span class="n">cursor</span><span
class="p">()</span> <span class="k">as</span> <span class="n">cur</span><span
class="p">:</span>
+<span class="linenos">43</span> <span class="n">cur</span><span
class="o">.</span><span class="n">execute</span><span class="p">(</span><span
class="s2">"SELECT * FROM autocommit_test"</span><span
class="p">)</span>
+<span class="linenos">44</span> <span class="k">assert</span> <span
class="n">cur</span><span class="o">.</span><span
class="n">fetchone</span><span class="p">()</span> <span class="o">==</span>
<span class="p">(</span><span class="mi">1</span><span class="p">,)</span>
+<span class="linenos">45</span>
+<span class="linenos">46</span><span class="n">conn</span><span
class="o">.</span><span class="n">close</span><span class="p">()</span>
+</pre></div>
+</div>
+</section>
<section id="create-append-to-a-table-from-an-arrow-dataset">
<span id="recipe-postgresql-create-append"></span><h2>Create/append to a table
from an Arrow dataset<a class="headerlink"
href="#create-append-to-a-table-from-an-arrow-dataset" title="Link to this
heading">¶</a></h2>
-<p id="index-1">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_create_dataset_table.py";>postgresql_create_dataset_table.py</a></p>
+<p id="index-2">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_create_dataset_table.py";>postgresql_create_dataset_table.py</a></p>
<p>ADBC makes it easy to load PyArrow datasets into your datastore.</p>
<div class="highlight-python notranslate"><div
class="highlight"><pre><span></span><span class="linenos">24</span><span
class="kn">import</span><span class="w"> </span><span class="nn">os</span>
<span class="linenos">25</span><span class="kn">import</span><span class="w">
</span><span class="nn">tempfile</span>
@@ -610,7 +641,7 @@ PostgreSQL, though.</p>
</section>
<section id="create-append-to-a-table-from-an-arrow-table">
<h2>Create/append to a table from an Arrow table<a class="headerlink"
href="#create-append-to-a-table-from-an-arrow-table" title="Link to this
heading">¶</a></h2>
-<p id="index-2">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_create_append_table.py";>postgresql_create_append_table.py</a></p>
+<p id="index-3">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_create_append_table.py";>postgresql_create_append_table.py</a></p>
<p>ADBC allows creating and appending to database tables using Arrow
tables.</p>
<div class="highlight-python notranslate"><div
class="highlight"><pre><span></span><span class="linenos">24</span><span
class="kn">import</span><span class="w"> </span><span class="nn">os</span>
@@ -705,7 +736,7 @@ append.</p>
</section>
<section id="create-append-to-a-temporary-table">
<h2>Create/append to a temporary table<a class="headerlink"
href="#create-append-to-a-temporary-table" title="Link to this
heading">¶</a></h2>
-<p id="index-3">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_create_temp_table.py";>postgresql_create_temp_table.py</a></p>
+<p id="index-4">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_create_temp_table.py";>postgresql_create_temp_table.py</a></p>
<p>ADBC allows creating and appending to temporary tables as well.</p>
<div class="highlight-python notranslate"><div
class="highlight"><pre><span></span><span class="linenos">23</span><span
class="kn">import</span><span class="w"> </span><span class="nn">os</span>
<span class="linenos">24</span>
@@ -785,7 +816,7 @@ If we reconnect, the table won’t exist; we’ll see only the
‘normal’ tabl
</section>
<section id="execute-a-statement-with-bind-parameters">
<h2>Execute a statement with bind parameters<a class="headerlink"
href="#execute-a-statement-with-bind-parameters" title="Link to this
heading">¶</a></h2>
-<p id="index-4">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_execute_bind.py";>postgresql_execute_bind.py</a></p>
+<p id="index-5">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_execute_bind.py";>postgresql_execute_bind.py</a></p>
<p>ADBC allows using Python and Arrow values as bind parameters.
Right now, the PostgreSQL driver only supports bind parameters
for queries that don’t generate result sets.</p>
@@ -841,7 +872,7 @@ is not supported—only the PostgreSQL-native <code
class="docutils literal notr
</section>
<section id="execute-a-statement-without-copy">
<span id="recipe-postgresql-statement-nocopy"></span><h2>Execute a statement
without COPY<a class="headerlink" href="#execute-a-statement-without-copy"
title="Link to this heading">¶</a></h2>
-<p id="index-5">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_execute_nocopy.py";>postgresql_execute_nocopy.py</a></p>
+<p id="index-6">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_execute_nocopy.py";>postgresql_execute_nocopy.py</a></p>
<p>The ADBC driver tries to execute queries with COPY by default since it is
faster for large result sets. PostgreSQL does not support <code
class="docutils literal notranslate"><span class="pre">COPY</span></code> for
all
kinds of queries, however. For example, <code class="docutils literal
notranslate"><span class="pre">SHOW</span></code> queries will not work.
@@ -902,7 +933,7 @@ description: string
</section>
<section id="get-the-arrow-schema-of-a-table">
<h2>Get the Arrow schema of a table<a class="headerlink"
href="#get-the-arrow-schema-of-a-table" title="Link to this heading">¶</a></h2>
-<p id="index-6">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_get_table_schema.py";>postgresql_get_table_schema.py</a></p>
+<p id="index-7">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_get_table_schema.py";>postgresql_get_table_schema.py</a></p>
<p>ADBC lets you get the schema of a table as an Arrow schema.</p>
<div class="highlight-python notranslate"><div
class="highlight"><pre><span></span><span class="linenos">24</span><span
class="kn">import</span><span class="w"> </span><span class="nn">os</span>
<span class="linenos">25</span>
@@ -961,7 +992,7 @@ decimals do not map onto Arrow decimals.</p>
</section>
<section id="get-the-arrow-schema-of-a-query">
<h2>Get the Arrow schema of a query<a class="headerlink"
href="#get-the-arrow-schema-of-a-query" title="Link to this heading">¶</a></h2>
-<p id="index-7">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_get_query_schema.py";>postgresql_get_query_schema.py</a></p>
+<p id="index-8">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_get_query_schema.py";>postgresql_get_query_schema.py</a></p>
<p>ADBC lets you get the schema of a result set, without executing the
query.</p>
<div class="highlight-python notranslate"><div
class="highlight"><pre><span></span><span class="linenos">24</span><span
class="kn">import</span><span class="w"> </span><span class="nn">os</span>
<span class="linenos">25</span>
@@ -1004,7 +1035,7 @@ decimals do not map onto Arrow decimals.</p>
</section>
<section id="list-catalogs-schemas-and-tables">
<h2>List catalogs, schemas, and tables<a class="headerlink"
href="#list-catalogs-schemas-and-tables" title="Link to this heading">¶</a></h2>
-<p id="index-8">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_list_catalogs.py";>postgresql_list_catalogs.py</a></p>
+<p id="index-9">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_list_catalogs.py";>postgresql_list_catalogs.py</a></p>
<p>ADBC allows listing tables, catalogs, and schemas in the database.</p>
<div class="highlight-python notranslate"><div
class="highlight"><pre><span></span><span class="linenos">24</span><span
class="kn">import</span><span class="w"> </span><span class="nn">os</span>
<span class="linenos">25</span>
@@ -1048,7 +1079,7 @@ decimals do not map onto Arrow decimals.</p>
</section>
<section id="connection-pooling-with-sqlalchemy">
<h2>Connection pooling with SQLAlchemy<a class="headerlink"
href="#connection-pooling-with-sqlalchemy" title="Link to this
heading">¶</a></h2>
-<p id="index-9">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_pool.py";>postgresql_pool.py</a></p>
+<p id="index-10">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_pool.py";>postgresql_pool.py</a></p>
<p>ADBC does not implement connection pooling, as this is not generally a
feature of DBAPI drivers. Instead, use a third party connection pool
like the one built into <a class="reference external"
href="https://docs.sqlalchemy.org/en/20/core/pooling.html";>SQLAlchemy</a>.</p>
@@ -1097,7 +1128,7 @@ protocol, unlike the underlying ADBC connection.</p>
</section>
<section id="using-pandas-and-adbc">
<h2>Using Pandas and ADBC<a class="headerlink" href="#using-pandas-and-adbc"
title="Link to this heading">¶</a></h2>
-<p id="index-10">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_pandas.py";>postgresql_pandas.py</a></p>
+<p id="index-11">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_pandas.py";>postgresql_pandas.py</a></p>
<p>ADBC is integrated into <a class="reference external"
href="https://pandas.pydata.org/";>pandas</a>, a popular dataframe library.
Pandas can
use ADBC to exchange data with PostgreSQL and other databases. Compared to
using SQLAlchemy or other options, using ADBC with pandas can have better
@@ -1140,7 +1171,7 @@ level API, especially for those already using pandas.</p>
</section>
<section id="using-polars-and-adbc">
<h2>Using Polars and ADBC<a class="headerlink" href="#using-polars-and-adbc"
title="Link to this heading">¶</a></h2>
-<p id="index-11">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_polars.py";>postgresql_polars.py</a></p>
+<p id="index-12">Recipe source: <a class="reference external"
href="https://github.com/apache/arrow-adbc/blob/main/docs/source/python/recipe/postgresql_polars.py";>postgresql_polars.py</a></p>
<p>ADBC can be used with <a class="reference external"
href="https://pola.rs/";>Polars</a>, a dataframe library written in Rust. As per
its documentation:</p>
<blockquote>
@@ -1240,6 +1271,7 @@ United States and other countries.
<ul>
<li><a class="reference internal" href="#">PostgreSQL Recipes</a><ul>
<li><a class="reference internal"
href="#authenticate-with-a-username-and-password">Authenticate with a username
and password</a></li>
+<li><a class="reference internal" href="#enable-autocommit-mode">Enable
autocommit mode</a></li>
<li><a class="reference internal"
href="#create-append-to-a-table-from-an-arrow-dataset">Create/append to a table
from an Arrow dataset</a><ul>
<li><a class="reference internal" href="#generating-sample-data">Generating
sample data</a></li>
<li><a class="reference internal"
href="#loading-csv-files-into-postgresql">Loading CSV Files into
PostgreSQL</a></li>
diff --git a/main/r/adbcbigquery/pkgdown.yml b/main/r/adbcbigquery/pkgdown.yml
index f51fb179a..8900cc920 100644
--- a/main/r/adbcbigquery/pkgdown.yml
+++ b/main/r/adbcbigquery/pkgdown.yml
@@ -2,7 +2,7 @@ pandoc: 3.8.2.1
pkgdown: 2.1.3
pkgdown_sha: ~
articles: {}
-last_built: 2025-10-22T21:19Z
+last_built: 2025-10-23T06:30Z
urls:
reference: https://arrow.apache.org/adbc/current/r/adbcbigquery/reference
article: https://arrow.apache.org/adbc/current/r/adbcbigquery/articles
diff --git a/main/r/adbcdrivermanager/pkgdown.yml
b/main/r/adbcdrivermanager/pkgdown.yml
index 84a535563..bcab92856 100644
--- a/main/r/adbcdrivermanager/pkgdown.yml
+++ b/main/r/adbcdrivermanager/pkgdown.yml
@@ -2,7 +2,7 @@ pandoc: 3.8.2.1
pkgdown: 2.1.3
pkgdown_sha: ~
articles: {}
-last_built: 2025-10-22T21:18Z
+last_built: 2025-10-23T06:30Z
urls:
reference:
https://arrow.apache.org/adbc/current/r/adbcdrivermanager/reference
article: https://arrow.apache.org/adbc/current/r/adbcdrivermanager/articles
diff --git a/main/r/adbcdrivermanager/reference/adbc_connection_init.html
b/main/r/adbcdrivermanager/reference/adbc_connection_init.html
index 41a9f77ac..ded75fd43 100644
--- a/main/r/adbcdrivermanager/reference/adbc_connection_init.html
+++ b/main/r/adbcdrivermanager/reference/adbc_connection_init.html
@@ -105,9 +105,9 @@ finer-grained control over behaviour at the R
level.</p></dd>
<h2 id="ref-examples">Examples<a class="anchor" aria-label="anchor"
href="#ref-examples"></a></h2>
<div class="sourceCode"><pre class="sourceCode r"><code><span
class="r-in"><span><span class="va">db</span> <span class="op"><-</span>
<span class="fu"><a
href="adbc_database_init.html">adbc_database_init</a></span><span
class="op">(</span><span class="fu"><a
href="adbc_driver_void.html">adbc_driver_void</a></span><span
class="op">(</span><span class="op">)</span><span
class="op">)</span></span></span>
<span class="r-in"><span><span class="fu">adbc_connection_init</span><span
class="op">(</span><span class="va">db</span><span
class="op">)</span></span></span>
-<span class="r-out co"><span class="r-pr">#></span> <adbc_connection at
0x55ee5d937fc0> </span>
+<span class="r-out co"><span class="r-pr">#></span> <adbc_connection at
0x5578df1554a0> </span>
<span class="r-out co"><span class="r-pr">#></span> List of 1</span>
-<span class="r-out co"><span class="r-pr">#></span> $
database:<adbc_database at 0x55ee5daadc40> </span>
+<span class="r-out co"><span class="r-pr">#></span> $
database:<adbc_database at 0x5578df0aeeb0> </span>
<span class="r-out co"><span class="r-pr">#></span> List of 1</span>
<span class="r-out co"><span class="r-pr">#></span> ..$
driver:<adbc_driver_void> List of 4</span>
<span class="r-out co"><span class="r-pr">#></span> .. ..$ load_flags
: int 15</span>
diff --git a/main/r/adbcdrivermanager/reference/adbc_database_init.html
b/main/r/adbcdrivermanager/reference/adbc_database_init.html
index 3fea7b2e8..09464227a 100644
--- a/main/r/adbcdrivermanager/reference/adbc_database_init.html
+++ b/main/r/adbcdrivermanager/reference/adbc_database_init.html
@@ -104,7 +104,7 @@ finer-grained control over behaviour at the R
level.</p></dd>
<div class="section level2">
<h2 id="ref-examples">Examples<a class="anchor" aria-label="anchor"
href="#ref-examples"></a></h2>
<div class="sourceCode"><pre class="sourceCode r"><code><span
class="r-in"><span><span class="fu">adbc_database_init</span><span
class="op">(</span><span class="fu"><a
href="adbc_driver_void.html">adbc_driver_void</a></span><span
class="op">(</span><span class="op">)</span><span
class="op">)</span></span></span>
-<span class="r-out co"><span class="r-pr">#></span> <adbc_database at
0x55ee5dbf4660> </span>
+<span class="r-out co"><span class="r-pr">#></span> <adbc_database at
0x5578de39cf20> </span>
<span class="r-out co"><span class="r-pr">#></span> List of 1</span>
<span class="r-out co"><span class="r-pr">#></span> $
driver:<adbc_driver_void> List of 4</span>
<span class="r-out co"><span class="r-pr">#></span> ..$ load_flags :
int 15</span>
diff --git a/main/r/adbcdrivermanager/reference/adbc_statement_init.html
b/main/r/adbcdrivermanager/reference/adbc_statement_init.html
index 9947aa5df..0fd7e2010 100644
--- a/main/r/adbcdrivermanager/reference/adbc_statement_init.html
+++ b/main/r/adbcdrivermanager/reference/adbc_statement_init.html
@@ -106,11 +106,11 @@ finer-grained control over behaviour at the R
level.</p></dd>
<div class="sourceCode"><pre class="sourceCode r"><code><span
class="r-in"><span><span class="va">db</span> <span class="op"><-</span>
<span class="fu"><a
href="adbc_database_init.html">adbc_database_init</a></span><span
class="op">(</span><span class="fu"><a
href="adbc_driver_void.html">adbc_driver_void</a></span><span
class="op">(</span><span class="op">)</span><span
class="op">)</span></span></span>
<span class="r-in"><span><span class="va">con</span> <span
class="op"><-</span> <span class="fu"><a
href="adbc_connection_init.html">adbc_connection_init</a></span><span
class="op">(</span><span class="va">db</span><span
class="op">)</span></span></span>
<span class="r-in"><span><span class="fu">adbc_statement_init</span><span
class="op">(</span><span class="va">con</span><span
class="op">)</span></span></span>
-<span class="r-out co"><span class="r-pr">#></span> <adbc_statement at
0x55ee59e0d1f0> </span>
+<span class="r-out co"><span class="r-pr">#></span> <adbc_statement at
0x5578df404a30> </span>
<span class="r-out co"><span class="r-pr">#></span> List of 1</span>
-<span class="r-out co"><span class="r-pr">#></span> $
connection:<adbc_connection at 0x55ee5df15f00> </span>
+<span class="r-out co"><span class="r-pr">#></span> $
connection:<adbc_connection at 0x5578deb3d4e0> </span>
<span class="r-out co"><span class="r-pr">#></span> List of 1</span>
-<span class="r-out co"><span class="r-pr">#></span> ..$
database:<adbc_database at 0x55ee5cdbfb50> </span>
+<span class="r-out co"><span class="r-pr">#></span> ..$
database:<adbc_database at 0x5578de34ab80> </span>
<span class="r-out co"><span class="r-pr">#></span> List of 1</span>
<span class="r-out co"><span class="r-pr">#></span> .. ..$
driver:<adbc_driver_void> List of 4</span>
<span class="r-out co"><span class="r-pr">#></span> .. .. ..$ load_flags
: int 15</span>
diff --git a/main/r/adbcdrivermanager/search.json
b/main/r/adbcdrivermanager/search.json
index a463bdcbd..417e8254a 100644
--- a/main/r/adbcdrivermanager/search.json
+++ b/main/r/adbcdrivermanager/search.json
@@ -1 +1 @@
-[{"path":"https://arrow.apache.org/adbc/current/r/adbcdrivermanager/LICENSE.html","id":null,"dir":"","previous_headings":"","what":"Apache
License","title":"Apache License","text":"Version 2.0, January 2004
<http://www.apache.org/licenses/>","code":""},{"path":[]},{"path":"https://arrow.apache.org/adbc/current/r/adbcdrivermanager/LICENSE.html","id":"id_1-definitions","dir":"","previous_headings":"Terms
and Conditions for use, reproduction, and distribution","what":"1.
Definitions","title [...]
+[{"path":"https://arrow.apache.org/adbc/current/r/adbcdrivermanager/LICENSE.html","id":null,"dir":"","previous_headings":"","what":"Apache
License","title":"Apache License","text":"Version 2.0, January 2004
<http://www.apache.org/licenses/>","code":""},{"path":[]},{"path":"https://arrow.apache.org/adbc/current/r/adbcdrivermanager/LICENSE.html","id":"id_1-definitions","dir":"","previous_headings":"Terms
and Conditions for use, reproduction, and distribution","what":"1.
Definitions","title [...]
diff --git a/main/r/adbcflightsql/pkgdown.yml b/main/r/adbcflightsql/pkgdown.yml
index 39f8f1f29..2176f5487 100644
--- a/main/r/adbcflightsql/pkgdown.yml
+++ b/main/r/adbcflightsql/pkgdown.yml
@@ -2,7 +2,7 @@ pandoc: 3.8.2.1
pkgdown: 2.1.3
pkgdown_sha: ~
articles: {}
-last_built: 2025-10-22T21:19Z
+last_built: 2025-10-23T06:30Z
urls:
reference: https://arrow.apache.org/adbc/current/r/adbcflightsql/reference
article: https://arrow.apache.org/adbc/current/r/adbcflightsql/articles
diff --git a/main/r/adbcpostgresql/pkgdown.yml
b/main/r/adbcpostgresql/pkgdown.yml
index 82bff3230..7043fc840 100644
--- a/main/r/adbcpostgresql/pkgdown.yml
+++ b/main/r/adbcpostgresql/pkgdown.yml
@@ -2,7 +2,7 @@ pandoc: 3.8.2.1
pkgdown: 2.1.3
pkgdown_sha: ~
articles: {}
-last_built: 2025-10-22T21:19Z
+last_built: 2025-10-23T06:30Z
urls:
reference: https://arrow.apache.org/adbc/current/r/adbcpostgresql/reference
article: https://arrow.apache.org/adbc/current/r/adbcpostgresql/articles
diff --git a/main/r/adbcsnowflake/pkgdown.yml b/main/r/adbcsnowflake/pkgdown.yml
index 6add6d04d..c086ca47e 100644
--- a/main/r/adbcsnowflake/pkgdown.yml
+++ b/main/r/adbcsnowflake/pkgdown.yml
@@ -2,7 +2,7 @@ pandoc: 3.8.2.1
pkgdown: 2.1.3
pkgdown_sha: ~
articles: {}
-last_built: 2025-10-22T21:19Z
+last_built: 2025-10-23T06:30Z
urls:
reference: https://arrow.apache.org/adbc/current/r/adbcsnowflake/reference
article: https://arrow.apache.org/adbc/current/r/adbcsnowflake/articles
diff --git a/main/r/adbcsqlite/pkgdown.yml b/main/r/adbcsqlite/pkgdown.yml
index 6e53fe198..4e8751cb6 100644
--- a/main/r/adbcsqlite/pkgdown.yml
+++ b/main/r/adbcsqlite/pkgdown.yml
@@ -2,7 +2,7 @@ pandoc: 3.8.2.1
pkgdown: 2.1.3
pkgdown_sha: ~
articles: {}
-last_built: 2025-10-22T21:19Z
+last_built: 2025-10-23T06:30Z
urls:
reference: https://arrow.apache.org/adbc/current/r/adbcsqlite/reference
article: https://arrow.apache.org/adbc/current/r/adbcsqlite/articles
diff --git a/main/searchindex.js b/main/searchindex.js
index ae5f9dfaf..6d6b8e385 100644
--- a/main/searchindex.js
+++ b/main/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"ADBC API Standard":[[27,null]],"ADBC Driver
Manager and Manifests":[[24,null]],"API
Reference":[[3,"api-reference"],[32,"api-reference"],[42,"api-reference"],[51,"api-reference"]],"And
then what is the \u201cADBC JDBC
driver\u201d?":[[22,"and-then-what-is-the-adbc-jdbc-driver"]],"Apache Arrow
ADBC":[[30,null]],"Arrow type to PostgreSQL type
mapping":[[18,"id5"]],"Authenticate with a username and
password":[[48,"authenticate-with-a-username-and-password"]]," [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"ADBC API Standard":[[27,null]],"ADBC Driver
Manager and Manifests":[[24,null]],"API
Reference":[[3,"api-reference"],[32,"api-reference"],[42,"api-reference"],[51,"api-reference"]],"And
then what is the \u201cADBC JDBC
driver\u201d?":[[22,"and-then-what-is-the-adbc-jdbc-driver"]],"Apache Arrow
ADBC":[[30,null]],"Arrow type to PostgreSQL type
mapping":[[18,"id5"]],"Authenticate with a username and
password":[[48,"authenticate-with-a-username-and-password"]]," [...]
\ No newline at end of file
