PageRenderTime 35ms CodeModel.GetById 75ms RepoModel.GetById 18ms app.codeStats 1ms

/doc/html/genindex.html

https://github.com/hhru/lucid-python-psycopg2
HTML | 948 lines | 912 code | 36 blank | 0 comment | 0 complexity | eff7c2b485cece8dc36e4ac71bf8cc6e MD5 | raw file
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  2. "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html xmlns="http://www.w3.org/1999/xhtml">
  4. <head>
  5. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  6. <title>Index &mdash; Psycopg v2.4.2 documentation</title>
  7. <link rel="stylesheet" href="_static/psycopg.css" type="text/css" />
  8. <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
  9. <script type="text/javascript">
  10. var DOCUMENTATION_OPTIONS = {
  11. URL_ROOT: '',
  12. VERSION: '2.4.2',
  13. COLLAPSE_INDEX: false,
  14. FILE_SUFFIX: '.html',
  15. HAS_SOURCE: true
  16. };
  17. </script>
  18. <script type="text/javascript" src="_static/jquery.js"></script>
  19. <script type="text/javascript" src="_static/underscore.js"></script>
  20. <script type="text/javascript" src="_static/doctools.js"></script>
  21. <link rel="top" title="Psycopg v2.4.2 documentation" href="index.html" />
  22. </head>
  23. <body>
  24. <div class="related">
  25. <h3>Navigation</h3>
  26. <ul>
  27. <li class="right" style="margin-right: 10px">
  28. <a href="#" title="General Index"
  29. accesskey="I">index</a></li>
  30. <li class="right" >
  31. <a href="py-modindex.html" title="Python Module Index"
  32. >modules</a> |</li>
  33. <li><a href="index.html">Psycopg v2.4.2 documentation</a> &raquo;</li>
  34. </ul>
  35. </div>
  36. <div class="document">
  37. <div class="documentwrapper">
  38. <div class="bodywrapper">
  39. <div class="body">
  40. <h1 id="index">Index</h1>
  41. <div class="genindex-jumpbox">
  42. <a href="#_"><strong>_</strong></a> | <a href="#A"><strong>A</strong></a> | <a href="#B"><strong>B</strong></a> | <a href="#C"><strong>C</strong></a> | <a href="#D"><strong>D</strong></a> | <a href="#E"><strong>E</strong></a> | <a href="#F"><strong>F</strong></a> | <a href="#G"><strong>G</strong></a> | <a href="#H"><strong>H</strong></a> | <a href="#I"><strong>I</strong></a> | <a href="#L"><strong>L</strong></a> | <a href="#M"><strong>M</strong></a> | <a href="#N"><strong>N</strong></a> | <a href="#O"><strong>O</strong></a> | <a href="#P"><strong>P</strong></a> | <a href="#Q"><strong>Q</strong></a> | <a href="#R"><strong>R</strong></a> | <a href="#S"><strong>S</strong></a> | <a href="#T"><strong>T</strong></a> | <a href="#U"><strong>U</strong></a> | <a href="#V"><strong>V</strong></a> | <a href="#W"><strong>W</strong></a> | <a href="#X"><strong>X</strong></a>
  43. </div>
  44. <h2 id="_">_</h2>
  45. <table style="width: 100%" class="indextable genindextable"><tr>
  46. <td style="width: 33%" valign="top"><dl>
  47. <dt><a href="extensions.html#psycopg2.extensions.ISQLQuote._wrapped">_wrapped (psycopg2.extensions.ISQLQuote attribute)</a></dt>
  48. </dl></td>
  49. </tr></table>
  50. <h2 id="A">A</h2>
  51. <table style="width: 100%" class="indextable genindextable"><tr>
  52. <td style="width: 33%" valign="top"><dl>
  53. <dt><a href="pool.html#psycopg2.pool.AbstractConnectionPool">AbstractConnectionPool (class in psycopg2.pool)</a></dt>
  54. <dt><a href="extensions.html#psycopg2.extensions.adapt">adapt() (in module psycopg2.extensions)</a></dt>
  55. <dt><a href="usage.html#index-3">Adaptation</a></dt>
  56. <dd><dl>
  57. <dt><a href="usage.html#index-4">Boolean</a></dt>
  58. <dt><a href="advanced.html#index-2">Creating new adapters</a></dt>
  59. <dt><a href="usage.html#index-8">Date/Time objects</a></dt>
  60. <dt><a href="usage.html#index-9">Lists</a></dt>
  61. <dt><a href="usage.html#index-4">None</a></dt>
  62. <dt><a href="usage.html#index-3">Objects</a></dt>
  63. <dt><a href="usage.html#index-6">Strings</a></dt>
  64. <dt><a href="usage.html#index-10">Tuple</a></dt>
  65. <dt><a href="extras.html#index-4">dict</a></dt>
  66. <dt><a href="extras.html#index-5">namedtuple</a></dt>
  67. <dt><a href="usage.html#index-5">numbers</a></dt>
  68. <dt><a href="extras.html#index-5">tuple</a></dt>
  69. </dl></dd>
  70. <dt><a href="extensions.html#psycopg2.extensions.adapters">adapters (in module psycopg2.extensions)</a></dt>
  71. <dt><a href="module.html#psycopg2.apilevel">apilevel (in module psycopg2)</a></dt>
  72. <dt>Array</dt>
  73. <dd><dl>
  74. <dt><a href="usage.html#index-9">Adaptation</a></dt>
  75. </dl></dd>
  76. <dt><a href="cursor.html#cursor.arraysize">arraysize (cursor attribute)</a></dt>
  77. </dl></td>
  78. <td style="width: 33%" valign="top"><dl>
  79. <dt><a href="extensions.html#psycopg2.extensions.AsIs">AsIs (class in psycopg2.extensions)</a></dt>
  80. <dt><a href="connection.html#connection.async">async (connection attribute)</a></dt>
  81. <dt>Asynchronous</dt>
  82. <dd><dl>
  83. <dt><a href="advanced.html#index-7">Connection</a></dt>
  84. <dt><a href="advanced.html#index-6">Notifications</a></dt>
  85. </dl></dd>
  86. <dt><a href="extras.html#psycopg2.extras.CompositeCaster.attnames">attnames (psycopg2.extras.CompositeCaster attribute)</a></dt>
  87. <dt><a href="extras.html#psycopg2.extras.CompositeCaster.atttypes">atttypes (psycopg2.extras.CompositeCaster attribute)</a></dt>
  88. <dt><a href="usage.html#index-14">Autocommit</a></dt>
  89. <dd><dl>
  90. <dt><a href="connection.html#index-9">Transaction</a></dt>
  91. </dl></dd>
  92. <dt><a href="connection.html#connection.autocommit">autocommit (connection attribute)</a></dt>
  93. </dl></td>
  94. </tr></table>
  95. <h2 id="B">B</h2>
  96. <table style="width: 100%" class="indextable genindextable"><tr>
  97. <td style="width: 33%" valign="top"><dl>
  98. <dt>Backend</dt>
  99. <dd><dl>
  100. <dt><a href="connection.html#index-12">PID</a></dt>
  101. </dl></dd>
  102. <dt><a href="usage.html#index-14">Begin</a></dt>
  103. <dt><a href="extensions.html#psycopg2.extensions.Binary">Binary (class in psycopg2.extensions)</a></dt>
  104. <dt><a href="module.html#psycopg2.BINARY">BINARY (in module psycopg2)</a></dt>
  105. <dt><a href="usage.html#index-7">Binary string</a></dt>
  106. <dt><a href="module.html#psycopg2.Binary">Binary() (in module psycopg2)</a></dt>
  107. <dt><a href="extensions.html#psycopg2.extensions.BINARYARRAY">BINARYARRAY (in module psycopg2.extensions)</a></dt>
  108. <dt>Boolean</dt>
  109. <dd><dl>
  110. <dt><a href="usage.html#index-4">Adaptation</a></dt>
  111. </dl></dd>
  112. </dl></td>
  113. <td style="width: 33%" valign="top"><dl>
  114. <dt><a href="extensions.html#psycopg2.extensions.Boolean">Boolean (class in psycopg2.extensions)</a></dt>
  115. <dt><a href="extensions.html#psycopg2.extensions.BOOLEAN">BOOLEAN (in module psycopg2.extensions)</a></dt>
  116. <dt><a href="extensions.html#psycopg2.extensions.BOOLEANARRAY">BOOLEANARRAY (in module psycopg2.extensions)</a></dt>
  117. <dt><a href="extensions.html#psycopg2.extensions.Xid.bqual">bqual (psycopg2.extensions.Xid attribute)</a></dt>
  118. <dt>Buffer</dt>
  119. <dd><dl>
  120. <dt><a href="usage.html#index-7">Adaptation</a></dt>
  121. </dl></dd>
  122. <dt>bytea</dt>
  123. <dd><dl>
  124. <dt><a href="usage.html#index-7">Adaptation</a></dt>
  125. </dl></dd>
  126. <dt>bytearray</dt>
  127. <dd><dl>
  128. <dt><a href="usage.html#index-7">Adaptation</a></dt>
  129. </dl></dd>
  130. <dt>bytes</dt>
  131. <dd><dl>
  132. <dt><a href="usage.html#index-7">Adaptation</a></dt>
  133. </dl></dd>
  134. </dl></td>
  135. </tr></table>
  136. <h2 id="C">C</h2>
  137. <table style="width: 100%" class="indextable genindextable"><tr>
  138. <td style="width: 33%" valign="top"><dl>
  139. <dt><a href="cursor.html#cursor.callproc">callproc() (cursor method)</a></dt>
  140. <dt><a href="connection.html#connection.cancel">cancel() (connection method)</a></dt>
  141. <dt><a href="cursor.html#cursor.cast">cast() (cursor method)</a></dt>
  142. <dt><a href="extensions.html#psycopg2.extensions.Notify.channel">channel (psycopg2.extensions.Notify attribute)</a></dt>
  143. <dt>Client</dt>
  144. <dd><dl>
  145. <dt><a href="connection.html#index-10">Encoding</a></dt>
  146. <dt><a href="connection.html#index-11">Logging</a></dt>
  147. </dl></dd>
  148. <dt><a href="connection.html#connection.close">close() (connection method)</a></dt>
  149. <dd><dl>
  150. <dt><a href="cursor.html#cursor.close">(cursor method)</a></dt>
  151. <dt><a href="extensions.html#psycopg2.extensions.lobject.close">(psycopg2.extensions.lobject method)</a></dt>
  152. </dl></dd>
  153. <dt><a href="pool.html#psycopg2.pool.AbstractConnectionPool.closeall">closeall() (psycopg2.pool.AbstractConnectionPool method)</a></dt>
  154. <dt><a href="connection.html#connection.closed">closed (connection attribute)</a></dt>
  155. <dd><dl>
  156. <dt><a href="cursor.html#cursor.closed">(cursor attribute)</a></dt>
  157. <dt><a href="extensions.html#psycopg2.extensions.lobject.closed">(psycopg2.extensions.lobject attribute)</a></dt>
  158. </dl></dd>
  159. <dt><a href="usage.html#index-14">Commit</a></dt>
  160. <dd><dl>
  161. <dt><a href="connection.html#index-6">Prepared</a></dt>
  162. <dt><a href="connection.html#index-0">Transaction</a></dt>
  163. </dl></dd>
  164. <dt><a href="connection.html#connection.commit">commit() (connection method)</a></dt>
  165. <dt>Composite types</dt>
  166. <dd><dl>
  167. <dt><a href="extras.html#index-5">Data types</a></dt>
  168. </dl></dd>
  169. <dt><a href="extras.html#psycopg2.extras.CompositeCaster">CompositeCaster (class in psycopg2.extras)</a></dt>
  170. <dt><a href="module.html#psycopg2.connect">connect() (in module psycopg2)</a></dt>
  171. <dt>Connection</dt>
  172. <dd><dl>
  173. <dt><a href="advanced.html#index-7">Asynchronous</a></dt>
  174. <dt><a href="module.html#index-0">Parameters</a></dt>
  175. <dt><a href="pool.html#index-0">Pooling</a></dt>
  176. <dt><a href="connection.html#index-17">Status</a></dt>
  177. <dt><a href="advanced.html#index-0">Subclassing</a></dt>
  178. </dl></dd>
  179. </dl></td>
  180. <td style="width: 33%" valign="top"><dl>
  181. <dt><a href="connection.html#connection">connection (built-in class)</a></dt>
  182. <dd><dl>
  183. <dt><a href="extensions.html#psycopg2.extensions.connection">(class in psycopg2.extensions)</a></dt>
  184. <dt><a href="cursor.html#cursor.connection">(cursor attribute)</a></dt>
  185. </dl></dd>
  186. <dt>Connection status</dt>
  187. <dd><dl>
  188. <dt><a href="extensions.html#index-6">Constants</a></dt>
  189. </dl></dd>
  190. <dt><a href="module.html#index-0">Connection string</a></dt>
  191. <dt>Constants</dt>
  192. <dd><dl>
  193. <dt><a href="extensions.html#index-6">Connection status</a></dt>
  194. <dt><a href="extensions.html#index-4">Isolation level</a></dt>
  195. <dt><a href="extensions.html#index-7">Poll status</a></dt>
  196. <dt><a href="extensions.html#index-5">Transaction status</a></dt>
  197. </dl></dd>
  198. <dt>COPY</dt>
  199. <dd><dl>
  200. <dt><a href="usage.html#index-17">SQL command</a></dt>
  201. </dl></dd>
  202. <dt><a href="cursor.html#cursor.copy_expert">copy_expert() (cursor method)</a></dt>
  203. <dt><a href="cursor.html#cursor.copy_from">copy_from() (cursor method)</a></dt>
  204. <dt><a href="cursor.html#cursor.copy_to">copy_to() (cursor method)</a></dt>
  205. <dt><a href="advanced.html#index-8">Coroutine</a></dt>
  206. <dt>Coroutine;</dt>
  207. <dd><dl>
  208. <dt><a href="extras.html#index-9">Example</a></dt>
  209. </dl></dd>
  210. <dt>Cursor</dt>
  211. <dd><dl>
  212. <dt><a href="extras.html#index-0">Dictionary</a></dt>
  213. <dt><a href="extras.html#index-2">Logging</a></dt>
  214. <dt><a href="usage.html#index-15">Named</a></dt>
  215. <dt><a href="usage.html#index-15">Server side</a></dt>
  216. <dt><a href="advanced.html#index-0">Subclassing</a></dt>
  217. <dt><a href="extras.html#index-1">namedtuple</a></dt>
  218. </dl></dd>
  219. <dt><a href="cursor.html#cursor">cursor (built-in class)</a></dt>
  220. <dd><dl>
  221. <dt><a href="extensions.html#psycopg2.extensions.cursor">(class in psycopg2.extensions)</a></dt>
  222. </dl></dd>
  223. <dt><a href="connection.html#connection.cursor">cursor() (connection method)</a></dt>
  224. </dl></td>
  225. </tr></table>
  226. <h2 id="D">D</h2>
  227. <table style="width: 100%" class="indextable genindextable"><tr>
  228. <td style="width: 33%" valign="top"><dl>
  229. <dt>Data types</dt>
  230. <dd><dl>
  231. <dt><a href="usage.html#index-3">Adaptation</a></dt>
  232. <dt><a href="extras.html#index-3">Additional</a></dt>
  233. <dt><a href="extras.html#index-5">Composite types</a></dt>
  234. <dt><a href="advanced.html#index-2">Creating new adapters</a></dt>
  235. <dt><a href="extras.html#index-7">INET</a></dt>
  236. <dt><a href="extras.html#index-6">UUID</a></dt>
  237. <dt><a href="extras.html#index-4">hstore</a></dt>
  238. </dl></dd>
  239. <dt><a href="extensions.html#psycopg2.extensions.Xid.database">database (psycopg2.extensions.Xid attribute)</a></dt>
  240. <dt><a href="module.html#psycopg2.DatabaseError">DatabaseError</a></dt>
  241. <dt><a href="module.html#psycopg2.DataError">DataError</a></dt>
  242. <dt><a href="extensions.html#psycopg2.extensions.DATE">DATE (in module psycopg2.extensions)</a></dt>
  243. <dt>Date objects</dt>
  244. <dd><dl>
  245. <dt><a href="usage.html#index-8">Adaptation</a></dt>
  246. </dl></dd>
  247. <dt><a href="module.html#psycopg2.Date">Date() (in module psycopg2)</a></dt>
  248. <dt><a href="extensions.html#psycopg2.extensions.DATEARRAY">DATEARRAY (in module psycopg2.extensions)</a></dt>
  249. <dt><a href="extensions.html#psycopg2.extensions.DateFromMx">DateFromMx (class in psycopg2.extensions)</a></dt>
  250. <dt><a href="extensions.html#psycopg2.extensions.DateFromPy">DateFromPy (class in psycopg2.extensions)</a></dt>
  251. <dt><a href="module.html#psycopg2.DateFromTicks">DateFromTicks() (in module psycopg2)</a></dt>
  252. <dt><a href="module.html#psycopg2.DATETIME">DATETIME (in module psycopg2)</a></dt>
  253. <dt><a href="extensions.html#psycopg2.extensions.DATETIMEARRAY">DATETIMEARRAY (in module psycopg2.extensions)</a></dt>
  254. </dl></td>
  255. <td style="width: 33%" valign="top"><dl>
  256. <dt>Decimal</dt>
  257. <dd><dl>
  258. <dt><a href="usage.html#index-5">Adaptation</a></dt>
  259. </dl></dd>
  260. <dt><a href="extensions.html#psycopg2.extensions.DECIMAL">DECIMAL (in module psycopg2.extensions)</a></dt>
  261. <dt><a href="extensions.html#psycopg2.extensions.DECIMALARRAY">DECIMALARRAY (in module psycopg2.extensions)</a></dt>
  262. <dt>DECLARE</dt>
  263. <dd><dl>
  264. <dt><a href="usage.html#index-15">SQL command</a></dt>
  265. </dl></dd>
  266. <dt><a href="cursor.html#cursor.description">description (cursor attribute)</a></dt>
  267. <dt>dict</dt>
  268. <dd><dl>
  269. <dt><a href="extras.html#index-4">Adaptation</a>, <a href="usage.html#index-11">[1]</a></dt>
  270. </dl></dd>
  271. <dt><a href="extras.html#psycopg2.extras.DictConnection">DictConnection (class in psycopg2.extras)</a></dt>
  272. <dt><a href="extras.html#psycopg2.extras.DictCursor">DictCursor (class in psycopg2.extras)</a></dt>
  273. <dt>Dictionary</dt>
  274. <dd><dl>
  275. <dt><a href="extras.html#index-0">Cursor</a></dt>
  276. </dl></dd>
  277. <dt><a href="extras.html#psycopg2.extras.DictRow">DictRow (class in psycopg2.extras)</a></dt>
  278. <dt><a href="connection.html#connection.dsn">dsn (connection attribute)</a></dt>
  279. <dt><a href="module.html#index-0">DSN (Database Source Name)</a></dt>
  280. </dl></td>
  281. </tr></table>
  282. <h2 id="E">E</h2>
  283. <table style="width: 100%" class="indextable genindextable"><tr>
  284. <td style="width: 33%" valign="top"><dl>
  285. <dt>Encoding</dt>
  286. <dd><dl>
  287. <dt><a href="connection.html#index-10">Client</a></dt>
  288. <dt><a href="extensions.html#index-2">Mapping</a></dt>
  289. </dl></dd>
  290. <dt><a href="connection.html#connection.encoding">encoding (connection attribute)</a></dt>
  291. <dt><a href="extensions.html#psycopg2.extensions.encodings">encodings (in module psycopg2.extensions)</a></dt>
  292. <dt>environment variable</dt>
  293. <dd><dl>
  294. <dt><a href="cursor.html#index-0">PSYCOPG_DISPLAY_SIZE</a></dt>
  295. <dt><a href="faq.html#index-0">PYTHON_EGG_CACHE</a></dt>
  296. <dt><a href="extensions.html#index-1">standard_conforming_string</a></dt>
  297. </dl></dd>
  298. <dt><a href="module.html#psycopg2.Error">Error</a></dt>
  299. <dd><dl>
  300. <dt><a href="errorcodes.html#index-0">Codes</a></dt>
  301. </dl></dd>
  302. <dt><a href="advanced.html#index-8">Eventlet</a></dt>
  303. </dl></td>
  304. <td style="width: 33%" valign="top"><dl>
  305. <dt>Example</dt>
  306. <dd><dl>
  307. <dt><a href="extras.html#index-9">Coroutine;</a></dt>
  308. <dt><a href="advanced.html#index-1">Cursor subclass</a></dt>
  309. <dt><a href="advanced.html#index-4">Types adaptation</a></dt>
  310. <dt><a href="usage.html#index-0">Usage</a></dt>
  311. </dl></dd>
  312. <dt>Exceptions</dt>
  313. <dd><dl>
  314. <dt><a href="extensions.html#index-3">Additional</a></dt>
  315. <dt><a href="module.html#index-1">DB API</a></dt>
  316. <dt><a href="connection.html#index-3">In the connection class</a></dt>
  317. </dl></dd>
  318. <dt><a href="cursor.html#cursor.execute">execute() (cursor method)</a></dt>
  319. <dt><a href="cursor.html#cursor.executemany">executemany() (cursor method)</a></dt>
  320. <dt><a href="extensions.html#psycopg2.extensions.lobject.export">export() (psycopg2.extensions.lobject method)</a></dt>
  321. </dl></td>
  322. </tr></table>
  323. <h2 id="F">F</h2>
  324. <table style="width: 100%" class="indextable genindextable"><tr>
  325. <td style="width: 33%" valign="top"><dl>
  326. <dt>FETCH</dt>
  327. <dd><dl>
  328. <dt><a href="usage.html#index-15">SQL command</a></dt>
  329. </dl></dd>
  330. <dt><a href="cursor.html#cursor.fetchall">fetchall() (cursor method)</a></dt>
  331. <dt><a href="cursor.html#cursor.fetchmany">fetchmany() (cursor method)</a></dt>
  332. <dt><a href="cursor.html#cursor.fetchone">fetchone() (cursor method)</a></dt>
  333. <dt><a href="connection.html#connection.fileno">fileno() (connection method)</a></dt>
  334. <dt><a href="extras.html#psycopg2.extras.LoggingConnection.filter">filter() (psycopg2.extras.LoggingConnection method)</a></dt>
  335. <dt><a href="tz.html#psycopg2.tz.FixedOffsetTimezone">FixedOffsetTimezone (class in psycopg2.tz)</a></dt>
  336. </dl></td>
  337. <td style="width: 33%" valign="top"><dl>
  338. <dt>Float</dt>
  339. <dd><dl>
  340. <dt><a href="usage.html#index-5">Adaptation</a></dt>
  341. </dl></dd>
  342. <dt><a href="extensions.html#psycopg2.extensions.Float">Float (class in psycopg2.extensions)</a></dt>
  343. <dt><a href="extensions.html#psycopg2.extensions.FLOAT">FLOAT (in module psycopg2.extensions)</a></dt>
  344. <dt><a href="extensions.html#psycopg2.extensions.FLOATARRAY">FLOATARRAY (in module psycopg2.extensions)</a></dt>
  345. <dt><a href="extensions.html#psycopg2.extensions.Xid.format_id">format_id (psycopg2.extensions.Xid attribute)</a></dt>
  346. <dt><a href="extensions.html#psycopg2.extensions.Xid.from_string">from_string() (psycopg2.extensions.Xid method)</a></dt>
  347. </dl></td>
  348. </tr></table>
  349. <h2 id="G">G</h2>
  350. <table style="width: 100%" class="indextable genindextable"><tr>
  351. <td style="width: 33%" valign="top"><dl>
  352. <dt><a href="connection.html#connection.get_backend_pid">get_backend_pid() (connection method)</a></dt>
  353. <dt><a href="connection.html#connection.get_parameter_status">get_parameter_status() (connection method)</a></dt>
  354. <dt><a href="connection.html#connection.get_transaction_status">get_transaction_status() (connection method)</a></dt>
  355. <dt><a href="extensions.html#psycopg2.extensions.get_wait_callback">get_wait_callback() (in module psycopg2.extensions)</a></dt>
  356. <dt><a href="pool.html#psycopg2.pool.AbstractConnectionPool.getconn">getconn() (psycopg2.pool.AbstractConnectionPool method)</a></dt>
  357. </dl></td>
  358. <td style="width: 33%" valign="top"><dl>
  359. <dt><a href="extensions.html#psycopg2.extensions.AsIs.getquoted">getquoted() (psycopg2.extensions.AsIs method)</a></dt>
  360. <dd><dl>
  361. <dt><a href="extensions.html#psycopg2.extensions.Binary.getquoted">(psycopg2.extensions.Binary method)</a></dt>
  362. <dt><a href="extensions.html#psycopg2.extensions.ISQLQuote.getquoted">(psycopg2.extensions.ISQLQuote method)</a></dt>
  363. <dt><a href="extensions.html#psycopg2.extensions.QuotedString.getquoted">(psycopg2.extensions.QuotedString method)</a></dt>
  364. </dl></dd>
  365. <dt><a href="advanced.html#index-8">gevent</a></dt>
  366. <dt><a href="advanced.html#index-8">Greenlet</a></dt>
  367. <dt><a href="extensions.html#psycopg2.extensions.Xid.gtrid">gtrid (psycopg2.extensions.Xid attribute)</a></dt>
  368. </dl></td>
  369. </tr></table>
  370. <h2 id="H">H</h2>
  371. <table style="width: 100%" class="indextable genindextable"><tr>
  372. <td style="width: 33%" valign="top"><dl>
  373. <dt>Host</dt>
  374. <dd><dl>
  375. <dt><a href="module.html#index-0">Connection</a></dt>
  376. </dl></dd>
  377. </dl></td>
  378. <td style="width: 33%" valign="top"><dl>
  379. <dt>hstore</dt>
  380. <dd><dl>
  381. <dt><a href="usage.html#index-11">Adaptation</a></dt>
  382. <dt><a href="extras.html#index-4">Data types</a></dt>
  383. </dl></dd>
  384. </dl></td>
  385. </tr></table>
  386. <h2 id="I">I</h2>
  387. <table style="width: 100%" class="indextable genindextable"><tr>
  388. <td style="width: 33%" valign="top"><dl>
  389. <dt><a href="usage.html#index-10">IN operator</a></dt>
  390. <dt>INET</dt>
  391. <dd><dl>
  392. <dt><a href="extras.html#index-7">Data types</a></dt>
  393. </dl></dd>
  394. <dt><a href="extras.html#psycopg2.extras.Inet">Inet (class in psycopg2.extras)</a></dt>
  395. <dt><a href="extras.html#psycopg2.extras.LoggingConnection.initialize">initialize() (psycopg2.extras.LoggingConnection method)</a></dt>
  396. <dt>Integer</dt>
  397. <dd><dl>
  398. <dt><a href="usage.html#index-5">Adaptation</a></dt>
  399. </dl></dd>
  400. <dt><a href="extensions.html#psycopg2.extensions.INTEGER">INTEGER (in module psycopg2.extensions)</a></dt>
  401. <dt><a href="extensions.html#psycopg2.extensions.INTEGERARRAY">INTEGERARRAY (in module psycopg2.extensions)</a></dt>
  402. <dt><a href="module.html#psycopg2.IntegrityError">IntegrityError</a></dt>
  403. <dt><a href="module.html#psycopg2.InterfaceError">InterfaceError</a></dt>
  404. <dt><a href="module.html#psycopg2.InternalError">InternalError</a></dt>
  405. <dt><a href="extensions.html#psycopg2.extensions.INTERVAL">INTERVAL (in module psycopg2.extensions)</a></dt>
  406. <dt>Interval objects</dt>
  407. <dd><dl>
  408. <dt><a href="usage.html#index-8">Adaptation</a></dt>
  409. </dl></dd>
  410. <dt><a href="extensions.html#psycopg2.extensions.INTERVALARRAY">INTERVALARRAY (in module psycopg2.extensions)</a></dt>
  411. </dl></td>
  412. <td style="width: 33%" valign="top"><dl>
  413. <dt><a href="extensions.html#psycopg2.extensions.IntervalFromMx">IntervalFromMx (class in psycopg2.extensions)</a></dt>
  414. <dt><a href="extensions.html#psycopg2.extensions.IntervalFromPy">IntervalFromPy (class in psycopg2.extensions)</a></dt>
  415. <dt><a href="connection.html#connection.isexecuting">isexecuting() (connection method)</a></dt>
  416. <dt>Isolation level</dt>
  417. <dd><dl>
  418. <dt><a href="extensions.html#index-4">Constants</a></dt>
  419. <dt><a href="connection.html#index-9">Transaction</a></dt>
  420. </dl></dd>
  421. <dt><a href="connection.html#connection.isolation_level">isolation_level (connection attribute)</a></dt>
  422. <dt><a href="extensions.html#psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT">ISOLATION_LEVEL_AUTOCOMMIT (in module psycopg2.extensions)</a></dt>
  423. <dt><a href="extensions.html#psycopg2.extensions.ISOLATION_LEVEL_READ_COMMITTED">ISOLATION_LEVEL_READ_COMMITTED (in module psycopg2.extensions)</a></dt>
  424. <dt><a href="extensions.html#psycopg2.extensions.ISOLATION_LEVEL_READ_UNCOMMITTED">ISOLATION_LEVEL_READ_UNCOMMITTED (in module psycopg2.extensions)</a></dt>
  425. <dt><a href="extensions.html#psycopg2.extensions.ISOLATION_LEVEL_REPEATABLE_READ">ISOLATION_LEVEL_REPEATABLE_READ (in module psycopg2.extensions)</a></dt>
  426. <dt><a href="extensions.html#psycopg2.extensions.ISOLATION_LEVEL_SERIALIZABLE">ISOLATION_LEVEL_SERIALIZABLE (in module psycopg2.extensions)</a></dt>
  427. <dt><a href="extensions.html#psycopg2.extensions.ISQLQuote">ISQLQuote (class in psycopg2.extensions)</a></dt>
  428. <dt><a href="cursor.html#cursor.itersize">itersize (cursor attribute)</a></dt>
  429. </dl></td>
  430. </tr></table>
  431. <h2 id="L">L</h2>
  432. <table style="width: 100%" class="indextable genindextable"><tr>
  433. <td style="width: 33%" valign="top"><dl>
  434. <dt><a href="usage.html#index-18">Large objects</a></dt>
  435. <dt><a href="cursor.html#cursor.lastrowid">lastrowid (cursor attribute)</a></dt>
  436. <dt>LISTEN</dt>
  437. <dd><dl>
  438. <dt><a href="advanced.html#index-6">SQL command</a></dt>
  439. </dl></dd>
  440. <dt>Lists</dt>
  441. <dd><dl>
  442. <dt><a href="usage.html#index-9">Adaptation</a></dt>
  443. </dl></dd>
  444. <dt><a href="extensions.html#psycopg2.extensions.lobject">lobject (class in psycopg2.extensions)</a></dt>
  445. <dt><a href="connection.html#connection.lobject">lobject() (connection method)</a></dt>
  446. <dt><a href="tz.html#psycopg2.tz.LocalTimezone">LocalTimezone (class in psycopg2.tz)</a></dt>
  447. </dl></td>
  448. <td style="width: 33%" valign="top"><dl>
  449. <dt>Logging</dt>
  450. <dd><dl>
  451. <dt><a href="connection.html#index-11">Client</a></dt>
  452. <dt><a href="extras.html#index-2">Cursor</a></dt>
  453. </dl></dd>
  454. <dt><a href="extras.html#psycopg2.extras.LoggingConnection">LoggingConnection (class in psycopg2.extras)</a></dt>
  455. <dt><a href="extras.html#psycopg2.extras.LoggingCursor">LoggingCursor (class in psycopg2.extras)</a></dt>
  456. <dt><a href="extensions.html#psycopg2.extensions.LONGINTEGER">LONGINTEGER (in module psycopg2.extensions)</a></dt>
  457. <dt><a href="extensions.html#psycopg2.extensions.LONGINTEGERARRAY">LONGINTEGERARRAY (in module psycopg2.extensions)</a></dt>
  458. <dt><a href="errorcodes.html#psycopg2.errorcodes.lookup">lookup() (in module psycopg2.errorcodes)</a></dt>
  459. </dl></td>
  460. </tr></table>
  461. <h2 id="M">M</h2>
  462. <table style="width: 100%" class="indextable genindextable"><tr>
  463. <td style="width: 33%" valign="top"><dl>
  464. <dt>memoryview</dt>
  465. <dd><dl>
  466. <dt><a href="usage.html#index-7">Adaptation</a></dt>
  467. </dl></dd>
  468. <dt><a href="extras.html#psycopg2.extras.MinTimeLoggingConnection">MinTimeLoggingConnection (class in psycopg2.extras)</a></dt>
  469. <dt><a href="extras.html#psycopg2.extras.MinTimeLoggingCursor">MinTimeLoggingCursor (class in psycopg2.extras)</a></dt>
  470. <dt><a href="extensions.html#psycopg2.extensions.lobject.mode">mode (psycopg2.extensions.lobject attribute)</a></dt>
  471. <dt><a href="cursor.html#cursor.mogrify">mogrify() (cursor method)</a></dt>
  472. <dt>MOVE</dt>
  473. <dd><dl>
  474. <dt><a href="usage.html#index-15">SQL command</a></dt>
  475. </dl></dd>
  476. <dt><a href="usage.html#index-16">Multiprocess</a></dt>
  477. <dt><a href="usage.html#index-16">Multithread</a></dt>
  478. <dd><dl>
  479. <dt><a href="pool.html#index-1">Connection pooling</a></dt>
  480. </dl></dd>
  481. <dt>mx.DateTime</dt>
  482. <dd><dl>
  483. <dt><a href="usage.html#index-8">Adaptation</a></dt>
  484. </dl></dd>
  485. </dl></td>
  486. <td style="width: 33%" valign="top"><dl>
  487. <dt><a href="extensions.html#psycopg2.extensions.MXDATE">MXDATE (in module psycopg2.extensions)</a></dt>
  488. <dt><a href="extensions.html#psycopg2.extensions.MXDATEARRAY">MXDATEARRAY (in module psycopg2.extensions)</a></dt>
  489. <dt><a href="extensions.html#psycopg2.extensions.MXDATETIME">MXDATETIME (in module psycopg2.extensions)</a></dt>
  490. <dt><a href="extensions.html#psycopg2.extensions.MXDATETIMEARRAY">MXDATETIMEARRAY (in module psycopg2.extensions)</a></dt>
  491. <dt><a href="extensions.html#psycopg2.extensions.MXINTERVAL">MXINTERVAL (in module psycopg2.extensions)</a></dt>
  492. <dt><a href="extensions.html#psycopg2.extensions.MXINTERVALARRAY">MXINTERVALARRAY (in module psycopg2.extensions)</a></dt>
  493. <dt><a href="extensions.html#psycopg2.extensions.MXTIME">MXTIME (in module psycopg2.extensions)</a></dt>
  494. <dt><a href="extensions.html#psycopg2.extensions.MXTIMEARRAY">MXTIMEARRAY (in module psycopg2.extensions)</a></dt>
  495. </dl></td>
  496. </tr></table>
  497. <h2 id="N">N</h2>
  498. <table style="width: 100%" class="indextable genindextable"><tr>
  499. <td style="width: 33%" valign="top"><dl>
  500. <dt><a href="cursor.html#cursor.name">name (cursor attribute)</a></dt>
  501. <dd><dl>
  502. <dt><a href="extras.html#psycopg2.extras.CompositeCaster.name">(psycopg2.extras.CompositeCaster attribute)</a></dt>
  503. </dl></dd>
  504. <dt>Named</dt>
  505. <dd><dl>
  506. <dt><a href="usage.html#index-15">Cursor</a></dt>
  507. </dl></dd>
  508. <dt>namedtuple</dt>
  509. <dd><dl>
  510. <dt><a href="extras.html#index-5">Adaptation</a></dt>
  511. <dt><a href="extras.html#index-1">Cursor</a></dt>
  512. </dl></dd>
  513. <dt><a href="extras.html#psycopg2.extras.NamedTupleConnection">NamedTupleConnection (class in psycopg2.extras)</a></dt>
  514. <dt><a href="extras.html#psycopg2.extras.NamedTupleCursor">NamedTupleCursor (class in psycopg2.extras)</a></dt>
  515. <dt><a href="extensions.html#psycopg2.extensions.new_type">new_type() (in module psycopg2.extensions)</a></dt>
  516. <dt><a href="cursor.html#cursor.nextset">nextset() (cursor method)</a></dt>
  517. <dt>None</dt>
  518. <dd><dl>
  519. <dt><a href="usage.html#index-4">Adaptation</a></dt>
  520. </dl></dd>
  521. </dl></td>
  522. <td style="width: 33%" valign="top"><dl>
  523. <dt><a href="connection.html#connection.notices">notices (connection attribute)</a></dt>
  524. <dt>Notifications</dt>
  525. <dd><dl>
  526. <dt><a href="advanced.html#index-6">Asynchronous</a></dt>
  527. </dl></dd>
  528. <dt><a href="connection.html#connection.notifies">notifies (connection attribute)</a></dt>
  529. <dt>NOTIFY</dt>
  530. <dd><dl>
  531. <dt><a href="advanced.html#index-6">SQL command</a></dt>
  532. </dl></dd>
  533. <dt><a href="extensions.html#psycopg2.extensions.Notify">Notify (class in psycopg2.extensions)</a></dt>
  534. <dt><a href="module.html#psycopg2.NotSupportedError">NotSupportedError</a></dt>
  535. <dt>NULL</dt>
  536. <dd><dl>
  537. <dt><a href="usage.html#index-4">Adaptation</a></dt>
  538. </dl></dd>
  539. <dt><a href="module.html#psycopg2.NUMBER">NUMBER (in module psycopg2)</a></dt>
  540. </dl></td>
  541. </tr></table>
  542. <h2 id="O">O</h2>
  543. <table style="width: 100%" class="indextable genindextable"><tr>
  544. <td style="width: 33%" valign="top"><dl>
  545. <dt>Objects</dt>
  546. <dd><dl>
  547. <dt><a href="usage.html#index-3">Adaptation</a></dt>
  548. <dt><a href="advanced.html#index-2">Creating new adapters</a></dt>
  549. </dl></dd>
  550. <dt><a href="cursor.html#index-1">oid</a></dt>
  551. <dd><dl>
  552. <dt><a href="extensions.html#psycopg2.extensions.lobject.oid">(psycopg2.extensions.lobject attribute)</a></dt>
  553. <dt><a href="extras.html#psycopg2.extras.CompositeCaster.oid">(psycopg2.extras.CompositeCaster attribute)</a></dt>
  554. </dl></dd>
  555. </dl></td>
  556. <td style="width: 33%" valign="top"><dl>
  557. <dt><a href="module.html#psycopg2.OperationalError">OperationalError</a></dt>
  558. <dt><a href="extensions.html#psycopg2.extensions.Xid.owner">owner (psycopg2.extensions.Xid attribute)</a></dt>
  559. </dl></td>
  560. </tr></table>
  561. <h2 id="P">P</h2>
  562. <table style="width: 100%" class="indextable genindextable"><tr>
  563. <td style="width: 33%" valign="top"><dl>
  564. <dt>Parameters</dt>
  565. <dd><dl>
  566. <dt><a href="module.html#index-0">Connection</a></dt>
  567. <dt><a href="usage.html#index-1">Query</a></dt>
  568. <dt><a href="connection.html#index-13">Server</a></dt>
  569. </dl></dd>
  570. <dt><a href="module.html#psycopg2.paramstyle">paramstyle (in module psycopg2)</a></dt>
  571. <dt>Password</dt>
  572. <dd><dl>
  573. <dt><a href="module.html#index-0">Connection</a></dt>
  574. </dl></dd>
  575. <dt><a href="extensions.html#psycopg2.extensions.Notify.payload">payload (psycopg2.extensions.Notify attribute)</a></dt>
  576. <dt><a href="pool.html#psycopg2.pool.PersistentConnectionPool">PersistentConnectionPool (class in psycopg2.pool)</a></dt>
  577. <dt>PgBouncer</dt>
  578. <dd><dl>
  579. <dt><a href="connection.html#index-2">unclean server</a></dt>
  580. </dl></dd>
  581. <dt><a href="module.html#psycopg2.Error.pgcode">pgcode (psycopg2.Error attribute)</a></dt>
  582. <dt><a href="module.html#psycopg2.Error.pgerror">pgerror (psycopg2.Error attribute)</a></dt>
  583. <dt>PID</dt>
  584. <dd><dl>
  585. <dt><a href="connection.html#index-12">Backend</a></dt>
  586. </dl></dd>
  587. <dt><a href="extensions.html#psycopg2.extensions.Notify.pid">pid (psycopg2.extensions.Notify attribute)</a></dt>
  588. <dt>Poll status</dt>
  589. <dd><dl>
  590. <dt><a href="extensions.html#index-7">Constants</a></dt>
  591. </dl></dd>
  592. <dt><a href="connection.html#connection.poll">poll() (connection method)</a></dt>
  593. <dt><a href="extensions.html#psycopg2.extensions.POLL_ERROR">POLL_ERROR (in module psycopg2.extensions)</a></dt>
  594. <dt><a href="extensions.html#psycopg2.extensions.POLL_OK">POLL_OK (in module psycopg2.extensions)</a></dt>
  595. <dt><a href="extensions.html#psycopg2.extensions.POLL_READ">POLL_READ (in module psycopg2.extensions)</a></dt>
  596. <dt><a href="extensions.html#psycopg2.extensions.POLL_WRITE">POLL_WRITE (in module psycopg2.extensions)</a></dt>
  597. <dt>Pooling</dt>
  598. <dd><dl>
  599. <dt><a href="pool.html#index-0">Connection</a></dt>
  600. </dl></dd>
  601. <dt>Port</dt>
  602. <dd><dl>
  603. <dt><a href="module.html#index-0">Connection</a></dt>
  604. </dl></dd>
  605. <dt>Prepare</dt>
  606. <dd><dl>
  607. <dt><a href="connection.html#index-5">Transaction</a></dt>
  608. </dl></dd>
  609. <dt><a href="extensions.html#psycopg2.extensions.ISQLQuote.prepare">prepare() (psycopg2.extensions.ISQLQuote method)</a></dt>
  610. <dt>Prepared</dt>
  611. <dd><dl>
  612. <dt><a href="connection.html#index-6">Commit</a></dt>
  613. <dt><a href="connection.html#index-7">Rollback</a></dt>
  614. </dl></dd>
  615. <dt><a href="extensions.html#psycopg2.extensions.Xid.prepared">prepared (psycopg2.extensions.Xid attribute)</a></dt>
  616. </dl></td>
  617. <td style="width: 33%" valign="top"><dl>
  618. <dt><a href="module.html#psycopg2.ProgrammingError">ProgrammingError</a></dt>
  619. <dt>Protocol</dt>
  620. <dd><dl>
  621. <dt><a href="connection.html#index-15">Version</a></dt>
  622. </dl></dd>
  623. <dt><a href="connection.html#connection.protocol_version">protocol_version (connection attribute)</a></dt>
  624. <dt><a href="module.html#module-psycopg2">psycopg2 (module)</a></dt>
  625. <dt><a href="errorcodes.html#module-psycopg2.errorcodes">psycopg2.errorcodes (module)</a></dt>
  626. <dt><a href="extensions.html#module-psycopg2.extensions">psycopg2.extensions (module)</a></dt>
  627. <dt><a href="extras.html#module-psycopg2.extras">psycopg2.extras (module)</a></dt>
  628. <dt><a href="pool.html#module-psycopg2.pool">psycopg2.pool (module)</a></dt>
  629. <dt><a href="tz.html#module-psycopg2.tz">psycopg2.tz (module)</a></dt>
  630. <dt><a href="cursor.html#index-0">PSYCOPG_DISPLAY_SIZE</a></dt>
  631. <dt><a href="pool.html#psycopg2.pool.AbstractConnectionPool.putconn">putconn() (psycopg2.pool.AbstractConnectionPool method)</a></dt>
  632. <dt><a href="extensions.html#psycopg2.extensions.PYDATE">PYDATE (in module psycopg2.extensions)</a></dt>
  633. <dt><a href="extensions.html#psycopg2.extensions.PYDATEARRAY">PYDATEARRAY (in module psycopg2.extensions)</a></dt>
  634. <dt><a href="extensions.html#psycopg2.extensions.PYDATETIME">PYDATETIME (in module psycopg2.extensions)</a></dt>
  635. <dt><a href="extensions.html#psycopg2.extensions.PYDATETIMEARRAY">PYDATETIMEARRAY (in module psycopg2.extensions)</a></dt>
  636. <dt><a href="extensions.html#psycopg2.extensions.PYINTERVAL">PYINTERVAL (in module psycopg2.extensions)</a></dt>
  637. <dt><a href="extensions.html#psycopg2.extensions.PYINTERVALARRAY">PYINTERVALARRAY (in module psycopg2.extensions)</a></dt>
  638. <dt><a href="extensions.html#index-0">Python Enhancement Proposals!PEP 246</a>, <a href="advanced.html#index-3">[1]</a></dt>
  639. <dt><a href="faq.html#index-0">PYTHON_EGG_CACHE</a></dt>
  640. <dt><a href="extensions.html#psycopg2.extensions.PYTIME">PYTIME (in module psycopg2.extensions)</a></dt>
  641. <dt><a href="extensions.html#psycopg2.extensions.PYTIMEARRAY">PYTIMEARRAY (in module psycopg2.extensions)</a></dt>
  642. </dl></td>
  643. </tr></table>
  644. <h2 id="Q">Q</h2>
  645. <table style="width: 100%" class="indextable genindextable"><tr>
  646. <td style="width: 33%" valign="top"><dl>
  647. <dt>Query</dt>
  648. <dd><dl>
  649. <dt><a href="usage.html#index-1">Parameters</a></dt>
  650. </dl></dd>
  651. <dt><a href="cursor.html#cursor.query">query (cursor attribute)</a></dt>
  652. </dl></td>
  653. <td style="width: 33%" valign="top"><dl>
  654. <dt><a href="extensions.html#psycopg2.extensions.QueryCanceledError">QueryCanceledError</a></dt>
  655. <dt><a href="extensions.html#psycopg2.extensions.QuotedString">QuotedString (class in psycopg2.extensions)</a></dt>
  656. </dl></td>
  657. </tr></table>
  658. <h2 id="R">R</h2>
  659. <table style="width: 100%" class="indextable genindextable"><tr>
  660. <td style="width: 33%" valign="top"><dl>
  661. <dt><a href="usage.html#index-14">Read only</a></dt>
  662. <dt><a href="extensions.html#psycopg2.extensions.lobject.read">read() (psycopg2.extensions.lobject method)</a></dt>
  663. <dt><a href="extras.html#psycopg2.extras.RealDictConnection">RealDictConnection (class in psycopg2.extras)</a></dt>
  664. <dt><a href="extras.html#psycopg2.extras.RealDictCursor">RealDictCursor (class in psycopg2.extras)</a></dt>
  665. <dt><a href="extras.html#psycopg2.extras.RealDictRow">RealDictRow (class in psycopg2.extras)</a></dt>
  666. <dt>Recover</dt>
  667. <dd><dl>
  668. <dt><a href="connection.html#index-8">Transaction</a></dt>
  669. </dl></dd>
  670. <dt><a href="extensions.html#psycopg2.extensions.register_adapter">register_adapter() (in module psycopg2.extensions)</a></dt>
  671. <dt><a href="extras.html#psycopg2.extras.register_composite">register_composite() (in module psycopg2.extras)</a></dt>
  672. <dt><a href="extras.html#psycopg2.extras.register_hstore">register_hstore() (in module psycopg2.extras)</a></dt>
  673. <dt><a href="extras.html#psycopg2.extras.register_inet">register_inet() (in module psycopg2.extras)</a></dt>
  674. </dl></td>
  675. <td style="width: 33%" valign="top"><dl>
  676. <dt><a href="extras.html#psycopg2.extras.register_tstz_w_secs">register_tstz_w_secs() (in module psycopg2.extras)</a></dt>
  677. <dt><a href="extensions.html#psycopg2.extensions.register_type">register_type() (in module psycopg2.extensions)</a></dt>
  678. <dt><a href="extras.html#psycopg2.extras.register_uuid">register_uuid() (in module psycopg2.extras)</a></dt>
  679. <dt><a href="connection.html#connection.reset">reset() (connection method)</a></dt>
  680. <dt><a href="usage.html#index-14">Rollback</a></dt>
  681. <dd><dl>
  682. <dt><a href="connection.html#index-7">Prepared</a></dt>
  683. <dt><a href="connection.html#index-1">Transaction</a></dt>
  684. </dl></dd>
  685. <dt><a href="connection.html#connection.rollback">rollback() (connection method)</a></dt>
  686. <dt><a href="cursor.html#cursor.rowcount">rowcount (cursor attribute)</a></dt>
  687. <dt><a href="module.html#psycopg2.ROWID">ROWID (in module psycopg2)</a></dt>
  688. <dt><a href="extensions.html#psycopg2.extensions.ROWIDARRAY">ROWIDARRAY (in module psycopg2.extensions)</a></dt>
  689. <dt><a href="cursor.html#cursor.rownumber">rownumber (cursor attribute)</a></dt>
  690. </dl></td>
  691. </tr></table>
  692. <h2 id="S">S</h2>
  693. <table style="width: 100%" class="indextable genindextable"><tr>
  694. <td style="width: 33%" valign="top"><dl>
  695. <dt><a href="cursor.html#cursor.scroll">scroll() (cursor method)</a></dt>
  696. <dt><a href="usage.html#index-2">Security</a></dt>
  697. <dt><a href="extensions.html#psycopg2.extensions.lobject.seek">seek() (psycopg2.extensions.lobject method)</a></dt>
  698. <dt>Server</dt>
  699. <dd><dl>
  700. <dt><a href="connection.html#index-13">Parameters</a></dt>
  701. <dt><a href="connection.html#index-16">Version</a></dt>
  702. </dl></dd>
  703. <dt>Server side</dt>
  704. <dd><dl>
  705. <dt><a href="usage.html#index-15">Cursor</a></dt>
  706. </dl></dd>
  707. <dt><a href="connection.html#connection.server_version">server_version (connection attribute)</a></dt>
  708. <dt><a href="connection.html#connection.set_client_encoding">set_client_encoding() (connection method)</a></dt>
  709. <dt><a href="connection.html#connection.set_isolation_level">set_isolation_level() (connection method)</a></dt>
  710. <dt><a href="connection.html#connection.set_session">set_session() (connection method)</a></dt>
  711. <dt><a href="extensions.html#psycopg2.extensions.set_wait_callback">set_wait_callback() (in module psycopg2.extensions)</a></dt>
  712. <dt><a href="cursor.html#cursor.setinputsizes">setinputsizes() (cursor method)</a></dt>
  713. <dt><a href="cursor.html#cursor.setoutputsize">setoutputsize() (cursor method)</a></dt>
  714. <dt><a href="pool.html#psycopg2.pool.SimpleConnectionPool">SimpleConnectionPool (class in psycopg2.pool)</a></dt>
  715. <dt>SQL command</dt>
  716. <dd><dl>
  717. <dt><a href="usage.html#index-17">COPY</a></dt>
  718. <dt><a href="usage.html#index-15">DECLARE</a></dt>
  719. <dt><a href="usage.html#index-15">FETCH</a></dt>
  720. <dt><a href="advanced.html#index-6">LISTEN</a></dt>
  721. <dt><a href="usage.html#index-15">MOVE</a></dt>
  722. <dt><a href="advanced.html#index-6">NOTIFY</a></dt>
  723. </dl></dd>
  724. <dt><a href="usage.html#index-2">SQL injection</a></dt>
  725. </dl></td>
  726. <td style="width: 33%" valign="top"><dl>
  727. <dt><a href="extensions.html#psycopg2.extensions.SQL_IN">SQL_IN (class in psycopg2.extensions)</a></dt>
  728. <dt><a href="extensions.html#index-1">standard_conforming_string</a></dt>
  729. <dt>Status</dt>
  730. <dd><dl>
  731. <dt><a href="connection.html#index-17">Connection</a></dt>
  732. <dt><a href="connection.html#index-14">Transaction</a></dt>
  733. </dl></dd>
  734. <dt><a href="connection.html#connection.status">status (connection attribute)</a></dt>
  735. <dt><a href="extensions.html#psycopg2.extensions.STATUS_BEGIN">STATUS_BEGIN (in module psycopg2.extensions)</a></dt>
  736. <dt><a href="extensions.html#psycopg2.extensions.STATUS_IN_TRANSACTION">STATUS_IN_TRANSACTION (in module psycopg2.extensions)</a></dt>
  737. <dt><a href="extensions.html#psycopg2.extensions.STATUS_PREPARED">STATUS_PREPARED (in module psycopg2.extensions)</a></dt>
  738. <dt><a href="extensions.html#psycopg2.extensions.STATUS_READY">STATUS_READY (in module psycopg2.extensions)</a></dt>
  739. <dt><a href="cursor.html#cursor.statusmessage">statusmessage (cursor attribute)</a></dt>
  740. <dt><a href="module.html#psycopg2.STRING">STRING (in module psycopg2)</a></dt>
  741. <dt><a href="extensions.html#psycopg2.extensions.string_types">string_types (in module psycopg2.extensions)</a></dt>
  742. <dt><a href="extensions.html#psycopg2.extensions.STRINGARRAY">STRINGARRAY (in module psycopg2.extensions)</a></dt>
  743. <dt>Strings</dt>
  744. <dd><dl>
  745. <dt><a href="usage.html#index-6">Adaptation</a></dt>
  746. </dl></dd>
  747. <dt>Subclassing</dt>
  748. <dd><dl>
  749. <dt><a href="advanced.html#index-0">Connection</a></dt>
  750. <dt><a href="advanced.html#index-0">Cursor</a></dt>
  751. </dl></dd>
  752. </dl></td>
  753. </tr></table>
  754. <h2 id="T">T</h2>
  755. <table style="width: 100%" class="indextable genindextable"><tr>
  756. <td style="width: 33%" valign="top"><dl>
  757. <dt><a href="extensions.html#psycopg2.extensions.lobject.tell">tell() (psycopg2.extensions.lobject method)</a></dt>
  758. <dt><a href="usage.html#index-16">Thread safety</a></dt>
  759. <dt><a href="pool.html#psycopg2.pool.ThreadedConnectionPool">ThreadedConnectionPool (class in psycopg2.pool)</a></dt>
  760. <dt><a href="module.html#psycopg2.threadsafety">threadsafety (in module psycopg2)</a></dt>
  761. <dt><a href="extensions.html#psycopg2.extensions.TIME">TIME (in module psycopg2.extensions)</a></dt>
  762. <dt>Time objects</dt>
  763. <dd><dl>
  764. <dt><a href="usage.html#index-8">Adaptation</a></dt>
  765. </dl></dd>
  766. <dt><a href="usage.html#index-13">Time Zones</a></dt>
  767. <dt>Time zones</dt>
  768. <dd><dl>
  769. <dt><a href="extras.html#index-8">Fractional</a></dt>
  770. </dl></dd>
  771. <dt><a href="module.html#psycopg2.Time">Time() (in module psycopg2)</a></dt>
  772. <dt><a href="extensions.html#psycopg2.extensions.TIMEARRAY">TIMEARRAY (in module psycopg2.extensions)</a></dt>
  773. <dt><a href="extensions.html#psycopg2.extensions.TimeFromMx">TimeFromMx (class in psycopg2.extensions)</a></dt>
  774. <dt><a href="extensions.html#psycopg2.extensions.TimeFromPy">TimeFromPy (class in psycopg2.extensions)</a></dt>
  775. <dt><a href="module.html#psycopg2.TimeFromTicks">TimeFromTicks() (in module psycopg2)</a></dt>
  776. <dt><a href="module.html#psycopg2.Timestamp">Timestamp() (in module psycopg2)</a></dt>
  777. <dt><a href="extensions.html#psycopg2.extensions.TimestampFromMx">TimestampFromMx (class in psycopg2.extensions)</a></dt>
  778. <dt><a href="extensions.html#psycopg2.extensions.TimestampFromPy">TimestampFromPy (class in psycopg2.extensions)</a></dt>
  779. <dt><a href="module.html#psycopg2.TimestampFromTicks">TimestampFromTicks() (in module psycopg2)</a></dt>
  780. <dt><a href="connection.html#connection.tpc_begin">tpc_begin() (connection method)</a></dt>
  781. <dt><a href="connection.html#connection.tpc_commit">tpc_commit() (connection method)</a></dt>
  782. </dl></td>
  783. <td style="width: 33%" valign="top"><dl>
  784. <dt><a href="connection.html#connection.tpc_prepare">tpc_prepare() (connection method)</a></dt>
  785. <dt><a href="connection.html#connection.tpc_recover">tpc_recover() (connection method)</a></dt>
  786. <dt><a href="connection.html#connection.tpc_rollback">tpc_rollback() (connection method)</a></dt>
  787. <dt><a href="usage.html#index-14">Transaction</a></dt>
  788. <dd><dl>
  789. <dt><a href="connection.html#index-9">Autocommit</a></dt>
  790. <dt><a href="connection.html#index-0">Commit</a></dt>
  791. <dt><a href="connection.html#index-9">Isolation level</a></dt>
  792. <dt><a href="connection.html#index-5">Prepare</a></dt>
  793. <dt><a href="connection.html#index-8">Recover</a></dt>
  794. <dt><a href="connection.html#index-1">Rollback</a></dt>
  795. <dt><a href="connection.html#index-14">Status</a></dt>
  796. <dt><a href="usage.html#index-19">Two-phase commit</a></dt>
  797. </dl></dd>
  798. <dt>Transaction status</dt>
  799. <dd><dl>
  800. <dt><a href="extensions.html#index-5">Constants</a></dt>
  801. </dl></dd>
  802. <dt><a href="extensions.html#psycopg2.extensions.TRANSACTION_STATUS_ACTIVE">TRANSACTION_STATUS_ACTIVE (in module psycopg2.extensions)</a></dt>
  803. <dt><a href="extensions.html#psycopg2.extensions.TRANSACTION_STATUS_IDLE">TRANSACTION_STATUS_IDLE (in module psycopg2.extensions)</a></dt>
  804. <dt><a href="extensions.html#psycopg2.extensions.TRANSACTION_STATUS_INERROR">TRANSACTION_STATUS_INERROR (in module psycopg2.extensions)</a></dt>
  805. <dt><a href="extensions.html#psycopg2.extensions.TRANSACTION_STATUS_INTRANS">TRANSACTION_STATUS_INTRANS (in module psycopg2.extensions)</a></dt>
  806. <dt><a href="extensions.html#psycopg2.extensions.TRANSACTION_STATUS_UNKNOWN">TRANSACTION_STATUS_UNKNOWN (in module psycopg2.extensions)</a></dt>
  807. <dt><a href="extensions.html#psycopg2.extensions.TransactionRollbackError">TransactionRollbackError</a></dt>
  808. <dt><a href="extensions.html#psycopg2.extensions.lobject.truncate">truncate() (psycopg2.extensions.lobject method)</a></dt>
  809. <dt>tuple</dt>
  810. <dd><dl>
  811. <dt><a href="extras.html#index-5">Adaptation</a></dt>
  812. </dl></dd>
  813. <dt>Tuple</dt>
  814. <dd><dl>
  815. <dt><a href="usage.html#index-10">Adaptation</a></dt>
  816. </dl></dd>
  817. <dt>Two-phase commit</dt>
  818. <dd><dl>
  819. <dt><a href="usage.html#index-19">Transaction</a></dt>
  820. <dt><a href="connection.html#index-4">methods</a></dt>
  821. </dl></dd>
  822. <dt><a href="extras.html#psycopg2.extras.CompositeCaster.type">type (psycopg2.extras.CompositeCaster attribute)</a></dt>
  823. <dt><a href="advanced.html#index-5">Type casting</a></dt>
  824. <dt><a href="cursor.html#cursor.tzinfo_factory">tzinfo_factory (cursor attribute)</a></dt>
  825. </dl></td>
  826. </tr></table>
  827. <h2 id="U">U</h2>
  828. <table style="width: 100%" class="indextable genindextable"><tr>
  829. <td style="width: 33%" valign="top"><dl>
  830. <dt><a href="usage.html#index-12">Unicode</a></dt>
  831. <dd><dl>
  832. <dt><a href="usage.html#index-6">Adaptation</a></dt>
  833. </dl></dd>
  834. <dt><a href="extensions.html#psycopg2.extensions.UNICODE">UNICODE (in module psycopg2.extensions)</a></dt>
  835. <dt><a href="extensions.html#psycopg2.extensions.UNICODEARRAY">UNICODEARRAY (in module psycopg2.extensions)</a></dt>
  836. <dt><a href="extensions.html#psycopg2.extensions.lobject.unlink">unlink() (psycopg2.extensions.lobject method)</a></dt>
  837. </dl></td>
  838. <td style="width: 33%" valign="top"><dl>
  839. <dt>Usage</dt>
  840. <dd><dl>
  841. <dt><a href="usage.html#index-0">Example</a></dt>
  842. </dl></dd>
  843. <dt>Username</dt>
  844. <dd><dl>
  845. <dt><a href="module.html#index-0">Connection</a></dt>
  846. </dl></dd>
  847. <dt>UUID</dt>
  848. <dd><dl>
  849. <dt><a href="extras.html#index-6">Data types</a></dt>
  850. </dl></dd>
  851. <dt><a href="extras.html#psycopg2.extras.UUID_adapter">UUID_adapter (class in psycopg2.extras)</a></dt>
  852. </dl></td>
  853. </tr></table>
  854. <h2 id="V">V</h2>
  855. <table style="width: 100%" class="indextable genindextable"><tr>
  856. <td style="width: 33%" valign="top"><dl>
  857. <dt>Version</dt>
  858. <dd><dl>
  859. <dt><a href="connection.html#index-15">Protocol</a></dt>
  860. <dt><a href="connection.html#index-16">Server</a></dt>
  861. </dl></dd>
  862. </dl></td>
  863. </tr></table>
  864. <h2 id="W">W</h2>
  865. <table style="width: 100%" class="indextable genindextable"><tr>
  866. <td style="width: 33%" valign="top"><dl>
  867. <dt><a href="advanced.html#index-8">Wait callback</a></dt>
  868. <dt><a href="extras.html#psycopg2.extras.wait_select">wait_select() (in module psycopg2.extras)</a></dt>
  869. </dl></td>
  870. <td style="width: 33%" valign="top"><dl>
  871. <dt><a href="module.html#psycopg2.Warning">Warning</a></dt>
  872. <dt><a href="extensions.html#psycopg2.extensions.lobject.write">write() (psycopg2.extensions.lobject method)</a></dt>
  873. </dl></td>
  874. </tr></table>
  875. <h2 id="X">X</h2>
  876. <table style="width: 100%" class="indextable genindextable"><tr>
  877. <td style="width: 33%" valign="top"><dl>
  878. <dt><a href="extensions.html#psycopg2.extensions.Xid">Xid (class in psycopg2.extensions)</a></dt>
  879. </dl></td>
  880. <td style="width: 33%" valign="top"><dl>
  881. <dt><a href="connection.html#connection.xid">xid() (connection method)</a></dt>
  882. </dl></td>
  883. </tr></table>
  884. </div>
  885. </div>
  886. </div>
  887. <div class="sphinxsidebar">
  888. <div class="sphinxsidebarwrapper">
  889. <div id="searchbox" style="display: none">
  890. <h3>Quick search</h3>
  891. <form class="search" action="search.html" method="get">
  892. <input type="text" name="q" size="18" />
  893. <input type="submit" value="Go" />
  894. <input type="hidden" name="check_keywords" value="yes" />
  895. <input type="hidden" name="area" value="default" />
  896. </form>
  897. <p class="searchtip" style="font-size: 90%">
  898. Enter search terms or a module, class or function name.
  899. </p>
  900. </div>
  901. <script type="text/javascript">$('#searchbox').show(0);</script>
  902. </div>
  903. </div>
  904. <div class="clearer"></div>
  905. </div>
  906. <div class="related">
  907. <h3>Navigation</h3>
  908. <ul>
  909. <li class="right" style="margin-right: 10px">
  910. <a href="#" title="General Index"
  911. >index</a></li>
  912. <li clas