codekingpro/portable-devtools

1<?xml version="1.0" encoding="UTF-8" standalone="no"?>2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>dblink_close</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="contrib-dblink-fetch.html" title="dblink_fetch" /><link rel="next" href="contrib-dblink-get-connections.html" title="dblink_get_connections" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">dblink_close</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="contrib-dblink-fetch.html" title="dblink_fetch">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="dblink.html" title="F.12. dblink — connect to other PostgreSQL databases">Up</a></td><th width="60%" align="center">F.12. dblink — connect to other PostgreSQL databases</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 16.3 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="contrib-dblink-get-connections.html" title="dblink_get_connections">Next</a></td></tr></table><hr /></div><div class="refentry" id="CONTRIB-DBLINK-CLOSE"><div class="titlepage"></div><a id="id-1.11.7.22.12.1" class="indexterm"></a><div class="refnamediv"><h2><span class="refentrytitle">dblink_close</span></h2><p>dblink_close — closes a cursor in a remote database</p></div><div class="refsynopsisdiv"><h2>Synopsis</h2><pre class="synopsis">3dblink_close(text cursorname [, bool fail_on_error]) returns text4dblink_close(text connname, text cursorname [, bool fail_on_error]) returns text5</pre></div><div class="refsect1" id="id-1.11.7.22.12.5"><h2>Description</h2><p>6    <code class="function">dblink_close</code> closes a cursor previously opened with7    <code class="function">dblink_open</code>.8   </p></div><div class="refsect1" id="id-1.11.7.22.12.6"><h2>Arguments</h2><div class="variablelist"><dl class="variablelist"><dt><span class="term"><em class="parameter"><code>connname</code></em></span></dt><dd><p>9       Name of the connection to use; omit this parameter to use the10       unnamed connection.11      </p></dd><dt><span class="term"><em class="parameter"><code>cursorname</code></em></span></dt><dd><p>12       The name of the cursor to close.13      </p></dd><dt><span class="term"><em class="parameter"><code>fail_on_error</code></em></span></dt><dd><p>14       If true (the default when omitted) then an error thrown on the15       remote side of the connection causes an error to also be thrown16       locally. If false, the remote error is locally reported as a NOTICE,17       and the function's return value is set to <code class="literal">ERROR</code>.18      </p></dd></dl></div></div><div class="refsect1" id="id-1.11.7.22.12.7"><h2>Return Value</h2><p>19    Returns status, either <code class="literal">OK</code> or <code class="literal">ERROR</code>.20   </p></div><div class="refsect1" id="id-1.11.7.22.12.8"><h2>Notes</h2><p>21    If <code class="function">dblink_open</code> started an explicit transaction block,22    and this is the last remaining open cursor in this connection,23    <code class="function">dblink_close</code> will issue the matching <code class="command">COMMIT</code>.24   </p></div><div class="refsect1" id="id-1.11.7.22.12.9"><h2>Examples</h2><pre class="screen">25SELECT dblink_connect('dbname=postgres options=-csearch_path=');26 dblink_connect27----------------28 OK29(1 row)30 31SELECT dblink_open('foo', 'select proname, prosrc from pg_proc');32 dblink_open33-------------34 OK35(1 row)36 37SELECT dblink_close('foo');38 dblink_close39--------------40 OK41(1 row)42</pre></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="contrib-dblink-fetch.html" title="dblink_fetch">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="dblink.html" title="F.12. dblink — connect to other PostgreSQL databases">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="contrib-dblink-get-connections.html" title="dblink_get_connections">Next</a></td></tr><tr><td width="40%" align="left" valign="top">dblink_fetch </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 16.3 Documentation">Home</a></td><td width="40%" align="right" valign="top"> dblink_get_connections</td></tr></table></div></body></html>