/usr/share/doc/python-psycopg2-doc/html/index.html is in python-psycopg2-doc 2.6.1-1build2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 | <!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>Psycopg – PostgreSQL database adapter for Python — Psycopg 2.0 documentation</title>
<link rel="stylesheet" href="_static/psycopg.css" type="text/css" />
<link rel="stylesheet" href="_static/pygments.css" type="text/css" />
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT: './',
VERSION: '2.0',
COLLAPSE_INDEX: false,
FILE_SUFFIX: '.html',
HAS_SOURCE: true
};
</script>
<script type="text/javascript" src="_static/jquery.js"></script>
<script type="text/javascript" src="_static/underscore.js"></script>
<script type="text/javascript" src="_static/doctools.js"></script>
<link rel="top" title="Psycopg 2.0 documentation" href="#" />
<link rel="next" title="Introduction" href="install.html" />
</head>
<body role="document">
<div class="related" role="navigation" aria-label="related navigation">
<h3>Navigation</h3>
<ul>
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
accesskey="I">index</a></li>
<li class="right" >
<a href="py-modindex.html" title="Python Module Index"
>modules</a> |</li>
<li class="right" >
<a href="install.html" title="Introduction"
accesskey="N">next</a> |</li>
<li class="nav-item nav-item-0"><a href="#">Psycopg 2.0 documentation</a> »</li>
</ul>
</div>
<div class="document">
<div class="documentwrapper">
<div class="bodywrapper">
<div class="body" role="main">
<div class="section" id="psycopg-postgresql-database-adapter-for-python">
<h1>Psycopg – PostgreSQL database adapter for Python<a class="headerlink" href="#psycopg-postgresql-database-adapter-for-python" title="Permalink to this headline">¶</a></h1>
<p><a class="reference external" href="http://initd.org/psycopg/">Psycopg</a> is the most popular <a class="reference external" href="http://www.postgresql.org/">PostgreSQL</a> database adapter for the <a class="reference external" href="http://www.python.org/">Python</a>
programming language. Its main features are the complete implementation of
the Python <a class="reference external" href="http://www.python.org/dev/peps/pep-0249/">DB API 2.0</a> specification and the thread safety (several threads can
share the same connection). It was designed for heavily multi-threaded
applications that create and destroy lots of cursors and make a large number
of concurrent <code class="sql docutils literal"><span class="pre">INSERT</span></code>s or <code class="sql docutils literal"><span class="pre">UPDATE</span></code>s.</p>
<p>Psycopg 2 is mostly implemented in C as a <a class="reference external" href="http://www.postgresql.org/docs/current/static/libpq.html">libpq</a> wrapper, resulting in being
both efficient and secure. It features client-side and <a class="reference internal" href="usage.html#server-side-cursors"><span>server-side</span></a> cursors, <a class="reference internal" href="advanced.html#async-support"><span>asynchronous communication</span></a> and <a class="reference internal" href="advanced.html#async-notify"><span>notifications</span></a>, <a class="reference external" href="http://www.postgresql.org/docs/current/static/sql-copy.html"><code class="sql docutils literal"><span class="pre">COPY</span> <span class="pre">TO/COPY</span> <span class="pre">FROM</span></code></a>
support. Many Python types are supported out-of-the-box and <a class="reference internal" href="usage.html#python-types-adaptation"><span>adapted to
matching PostgreSQL data types</span></a>; adaptation can be
extended and customized thanks to a flexible <a class="reference internal" href="advanced.html#adapting-new-types"><span>objects adaptation system</span></a>.</p>
<p>Psycopg 2 is both Unicode and Python 3 friendly.</p>
<p class="rubric">Contents</p>
<div class="toctree-wrapper compound">
<ul>
<li class="toctree-l1"><a class="reference internal" href="install.html">Introduction</a></li>
<li class="toctree-l1"><a class="reference internal" href="install.html#installation">Installation</a><ul>
<li class="toctree-l2"><a class="reference internal" href="install.html#install-from-a-package">Install from a package</a></li>
<li class="toctree-l2"><a class="reference internal" href="install.html#install-from-source">Install from source</a></li>
<li class="toctree-l2"><a class="reference internal" href="install.html#creating-a-debug-build">Creating a debug build</a></li>
<li class="toctree-l2"><a class="reference internal" href="install.html#if-you-still-have-problems">If you still have problems</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="usage.html">Basic module usage</a><ul>
<li class="toctree-l2"><a class="reference internal" href="usage.html#passing-parameters-to-sql-queries">Passing parameters to SQL queries</a></li>
<li class="toctree-l2"><a class="reference internal" href="usage.html#adaptation-of-python-values-to-sql-types">Adaptation of Python values to SQL types</a></li>
<li class="toctree-l2"><a class="reference internal" href="usage.html#transactions-control">Transactions control</a></li>
<li class="toctree-l2"><a class="reference internal" href="usage.html#server-side-cursors">Server side cursors</a></li>
<li class="toctree-l2"><a class="reference internal" href="usage.html#thread-and-process-safety">Thread and process safety</a></li>
<li class="toctree-l2"><a class="reference internal" href="usage.html#using-copy-to-and-copy-from">Using COPY TO and COPY FROM</a></li>
<li class="toctree-l2"><a class="reference internal" href="usage.html#access-to-postgresql-large-objects">Access to PostgreSQL large objects</a></li>
<li class="toctree-l2"><a class="reference internal" href="usage.html#two-phase-commit-protocol-support">Two-Phase Commit protocol support</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="module.html">The <code class="docutils literal"><span class="pre">psycopg2</span></code> module content</a><ul>
<li class="toctree-l2"><a class="reference internal" href="module.html#exceptions">Exceptions</a></li>
<li class="toctree-l2"><a class="reference internal" href="module.html#type-objects-and-constructors">Type Objects and Constructors</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="connection.html">The <code class="docutils literal"><span class="pre">connection</span></code> class</a></li>
<li class="toctree-l1"><a class="reference internal" href="cursor.html">The <code class="docutils literal"><span class="pre">cursor</span></code> class</a></li>
<li class="toctree-l1"><a class="reference internal" href="advanced.html">More advanced topics</a><ul>
<li class="toctree-l2"><a class="reference internal" href="advanced.html#connection-and-cursor-factories">Connection and cursor factories</a></li>
<li class="toctree-l2"><a class="reference internal" href="advanced.html#adapting-new-python-types-to-sql-syntax">Adapting new Python types to SQL syntax</a></li>
<li class="toctree-l2"><a class="reference internal" href="advanced.html#type-casting-of-sql-types-into-python-objects">Type casting of SQL types into Python objects</a></li>
<li class="toctree-l2"><a class="reference internal" href="advanced.html#asynchronous-notifications">Asynchronous notifications</a></li>
<li class="toctree-l2"><a class="reference internal" href="advanced.html#asynchronous-support">Asynchronous support</a></li>
<li class="toctree-l2"><a class="reference internal" href="advanced.html#support-for-coroutine-libraries">Support for coroutine libraries</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="extensions.html"><code class="docutils literal"><span class="pre">psycopg2.extensions</span></code> – Extensions to the DB API</a><ul>
<li class="toctree-l2"><a class="reference internal" href="extensions.html#sql-adaptation-protocol-objects">SQL adaptation protocol objects</a></li>
<li class="toctree-l2"><a class="reference internal" href="extensions.html#database-types-casting-functions">Database types casting functions</a></li>
<li class="toctree-l2"><a class="reference internal" href="extensions.html#additional-exceptions">Additional exceptions</a></li>
<li class="toctree-l2"><a class="reference internal" href="extensions.html#isolation-level-constants">Isolation level constants</a></li>
<li class="toctree-l2"><a class="reference internal" href="extensions.html#transaction-status-constants">Transaction status constants</a></li>
<li class="toctree-l2"><a class="reference internal" href="extensions.html#connection-status-constants">Connection status constants</a></li>
<li class="toctree-l2"><a class="reference internal" href="extensions.html#poll-constants">Poll constants</a></li>
<li class="toctree-l2"><a class="reference internal" href="extensions.html#additional-database-types">Additional database types</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="extras.html"><code class="docutils literal"><span class="pre">psycopg2.extras</span></code> – Miscellaneous goodies for Psycopg 2</a><ul>
<li class="toctree-l2"><a class="reference internal" href="extras.html#connection-and-cursor-subclasses">Connection and cursor subclasses</a></li>
<li class="toctree-l2"><a class="reference internal" href="extras.html#additional-data-types">Additional data types</a></li>
<li class="toctree-l2"><a class="reference internal" href="extras.html#fractional-time-zones">Fractional time zones</a></li>
<li class="toctree-l2"><a class="reference internal" href="extras.html#coroutine-support">Coroutine support</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="tz.html"><code class="docutils literal"><span class="pre">psycopg2.tz</span></code> – <code class="docutils literal"><span class="pre">tzinfo</span></code> implementations for Psycopg 2</a></li>
<li class="toctree-l1"><a class="reference internal" href="pool.html"><code class="docutils literal"><span class="pre">psycopg2.pool</span></code> – Connections pooling</a></li>
<li class="toctree-l1"><a class="reference internal" href="errorcodes.html"><code class="docutils literal"><span class="pre">psycopg2.errorcodes</span></code> – Error codes defined by PostgreSQL</a></li>
<li class="toctree-l1"><a class="reference internal" href="faq.html">Frequently Asked Questions</a><ul>
<li class="toctree-l2"><a class="reference internal" href="faq.html#problems-with-transactions-handling">Problems with transactions handling</a></li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#problems-with-type-conversions">Problems with type conversions</a></li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#best-practices">Best practices</a></li>
<li class="toctree-l2"><a class="reference internal" href="faq.html#problems-compiling-and-deploying-psycopg2">Problems compiling and deploying psycopg2</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="news.html">Release notes</a><ul>
<li class="toctree-l2"><a class="reference internal" href="news.html#current-release">Current release</a></li>
<li class="toctree-l2"><a class="reference internal" href="news.html#what-s-new-in-psycopg-2-6">What’s new in psycopg 2.6</a></li>
<li class="toctree-l2"><a class="reference internal" href="news.html#what-s-new-in-psycopg-2-5">What’s new in psycopg 2.5</a></li>
<li class="toctree-l2"><a class="reference internal" href="news.html#what-s-new-in-psycopg-2-4">What’s new in psycopg 2.4</a></li>
<li class="toctree-l2"><a class="reference internal" href="news.html#what-s-new-in-psycopg-2-3">What’s new in psycopg 2.3</a></li>
<li class="toctree-l2"><a class="reference internal" href="news.html#what-s-new-in-psycopg-2-2">What’s new in psycopg 2.2</a></li>
<li class="toctree-l2"><a class="reference internal" href="news.html#what-s-new-in-psycopg-2-0">What’s new in psycopg 2.0</a></li>
</ul>
</li>
</ul>
</div>
<p class="rubric">Indices and tables</p>
<ul class="simple">
<li><a class="reference internal" href="genindex.html"><span>Index</span></a></li>
<li><a class="reference internal" href="search.html"><span>Search Page</span></a></li>
</ul>
</div>
</div>
</div>
</div>
<div class="sphinxsidebar" role="navigation" aria-label="main navigation">
<div class="sphinxsidebarwrapper">
<h4>Next topic</h4>
<p class="topless"><a href="install.html"
title="next chapter">Introduction</a></p>
<div role="note" aria-label="source link">
<h3>This Page</h3>
<ul class="this-page-menu">
<li><a href="_sources/index.txt"
rel="nofollow">Show Source</a></li>
</ul>
</div>
<div id="searchbox" style="display: none" role="search">
<h3>Quick search</h3>
<form class="search" action="search.html" method="get">
<input type="text" name="q" />
<input type="submit" value="Go" />
<input type="hidden" name="check_keywords" value="yes" />
<input type="hidden" name="area" value="default" />
</form>
<p class="searchtip" style="font-size: 90%">
Enter search terms or a module, class or function name.
</p>
</div>
<script type="text/javascript">$('#searchbox').show(0);</script>
</div>
</div>
<div class="clearer"></div>
</div>
<div class="related" role="navigation" aria-label="related navigation">
<h3>Navigation</h3>
<ul>
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
>index</a></li>
<li class="right" >
<a href="py-modindex.html" title="Python Module Index"
>modules</a> |</li>
<li class="right" >
<a href="install.html" title="Introduction"
>next</a> |</li>
<li class="nav-item nav-item-0"><a href="#">Psycopg 2.0 documentation</a> »</li>
</ul>
</div>
<div class="footer" role="contentinfo">
© Copyright 2001-2016, Federico Di Gregorio, Daniele Varrazzo.
Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.3.4.
</div>
</body>
</html>
|