<!doctype html> <html xmlns="http://www.w3.org/1999/xhtml" lang="en"> <head> <meta http-equiv="X-UA-Compatible" content="IE=Edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>sqlobject.postgres.pgconnection module — SQLObject 3.7.0 documentation</title> <link rel="stylesheet" href="../_static/bizstyle.css" type="text/css" /> <link rel="stylesheet" href="../_static/pygments.css" type="text/css" /> <script type="text/javascript" src="../_static/documentation_options.js"></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> <script type="text/javascript" src="../_static/bizstyle.js"></script> <link rel="index" title="Index" href="../genindex.html" /> <link rel="search" title="Search" href="../search.html" /> <meta name="viewport" content="width=device-width,initial-scale=1.0"> <!--[if lt IE 9]> <script type="text/javascript" src="_static/css3-mediaqueries.js"></script> <![endif]--> </head><body> <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="nav-item nav-item-0"><a href="../index.html">SQLObject 3.7.0 documentation</a> »</li> </ul> </div> <div class="sphinxsidebar" role="navigation" aria-label="main navigation"> <div class="sphinxsidebarwrapper"> <div role="note" aria-label="source link"> <h3>This Page</h3> <ul class="this-page-menu"> <li><a href="../_sources/api/sqlobject.postgres.pgconnection.rst.txt" rel="nofollow">Show Source</a></li> </ul> </div> <div id="searchbox" style="display: none" role="search"> <h3>Quick search</h3> <div class="searchformwrapper"> <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> </div> </div> <script type="text/javascript">$('#searchbox').show(0);</script> </div> </div> <div class="document"> <div class="documentwrapper"> <div class="bodywrapper"> <div class="body" role="main"> <div class="section" id="module-sqlobject.postgres.pgconnection"> <span id="sqlobject-postgres-pgconnection-module"></span><h1>sqlobject.postgres.pgconnection module<a class="headerlink" href="#module-sqlobject.postgres.pgconnection" title="Permalink to this headline">¶</a></h1> <dl class="class"> <dt id="sqlobject.postgres.pgconnection.ErrorMessage"> <em class="property">class </em><code class="descclassname">sqlobject.postgres.pgconnection.</code><code class="descname">ErrorMessage</code><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#ErrorMessage"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.ErrorMessage" title="Permalink to this definition">¶</a></dt> <dd><p>Bases: <code class="xref py py-class docutils literal notranslate"><span class="pre">str</span></code></p> </dd></dl> <dl class="function"> <dt id="sqlobject.postgres.pgconnection.OdbcBinaryConverter"> <code class="descclassname">sqlobject.postgres.pgconnection.</code><code class="descname">OdbcBinaryConverter</code><span class="sig-paren">(</span><em>value</em>, <em>db</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#OdbcBinaryConverter"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.OdbcBinaryConverter" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="function"> <dt id="sqlobject.postgres.pgconnection.PostgresBinaryConverter"> <code class="descclassname">sqlobject.postgres.pgconnection.</code><code class="descname">PostgresBinaryConverter</code><span class="sig-paren">(</span><em>value</em>, <em>db</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresBinaryConverter"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresBinaryConverter" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="class"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection"> <em class="property">class </em><code class="descclassname">sqlobject.postgres.pgconnection.</code><code class="descname">PostgresConnection</code><span class="sig-paren">(</span><em>dsn=None</em>, <em>host=None</em>, <em>port=None</em>, <em>db=None</em>, <em>user=None</em>, <em>password=None</em>, <em>**kw</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection" title="Permalink to this definition">¶</a></dt> <dd><p>Bases: <a class="reference internal" href="sqlobject.dbconnection.html#sqlobject.dbconnection.DBAPI" title="sqlobject.dbconnection.DBAPI"><code class="xref py py-class docutils literal notranslate"><span class="pre">sqlobject.dbconnection.DBAPI</span></code></a></p> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.addColumn"> <code class="descname">addColumn</code><span class="sig-paren">(</span><em>tableName</em>, <em>column</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.addColumn"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.addColumn" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.columnsFromSchema"> <code class="descname">columnsFromSchema</code><span class="sig-paren">(</span><em>tableName</em>, <em>soClass</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.columnsFromSchema"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.columnsFromSchema" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.createColumn"> <code class="descname">createColumn</code><span class="sig-paren">(</span><em>soClass</em>, <em>col</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.createColumn"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.createColumn" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.createEmptyDatabase"> <code class="descname">createEmptyDatabase</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.createEmptyDatabase"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.createEmptyDatabase" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.createIDColumn"> <code class="descname">createIDColumn</code><span class="sig-paren">(</span><em>soClass</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.createIDColumn"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.createIDColumn" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.createIndexSQL"> <code class="descname">createIndexSQL</code><span class="sig-paren">(</span><em>soClass</em>, <em>index</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.createIndexSQL"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.createIndexSQL" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.createReferenceConstraint"> <code class="descname">createReferenceConstraint</code><span class="sig-paren">(</span><em>soClass</em>, <em>col</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.createReferenceConstraint"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.createReferenceConstraint" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="attribute"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.dbName"> <code class="descname">dbName</code><em class="property"> = 'postgres'</em><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.dbName" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.defaultFromSchema"> <code class="descname">defaultFromSchema</code><span class="sig-paren">(</span><em>colClass</em>, <em>defaultstr</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.defaultFromSchema"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.defaultFromSchema" title="Permalink to this definition">¶</a></dt> <dd><p>If the default can be converted to a python constant, convert it. Otherwise return is as a sqlbuilder constant.</p> </dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.delColumn"> <code class="descname">delColumn</code><span class="sig-paren">(</span><em>sqlmeta</em>, <em>column</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.delColumn"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.delColumn" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.dropDatabase"> <code class="descname">dropDatabase</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.dropDatabase"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.dropDatabase" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.dropTable"> <code class="descname">dropTable</code><span class="sig-paren">(</span><em>tableName</em>, <em>cascade=False</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.dropTable"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.dropTable" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.guessClass"> <code class="descname">guessClass</code><span class="sig-paren">(</span><em>t</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.guessClass"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.guessClass" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.joinSQLType"> <code class="descname">joinSQLType</code><span class="sig-paren">(</span><em>join</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.joinSQLType"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.joinSQLType" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.listDatabases"> <code class="descname">listDatabases</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.listDatabases"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.listDatabases" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.listTables"> <code class="descname">listTables</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.listTables"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.listTables" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.makeConnection"> <code class="descname">makeConnection</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.makeConnection"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.makeConnection" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="attribute"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.odbc_keywords"> <code class="descname">odbc_keywords</code><em class="property"> = ('Server', 'Port', 'UID', 'Password', 'Database')</em><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.odbc_keywords" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="attribute"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.schemes"> <code class="descname">schemes</code><em class="property"> = ['postgres', 'postgresql']</em><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.schemes" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="attribute"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.supportTransactions"> <code class="descname">supportTransactions</code><em class="property"> = True</em><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.supportTransactions" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.postgres.pgconnection.PostgresConnection.tableExists"> <code class="descname">tableExists</code><span class="sig-paren">(</span><em>tableName</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PostgresConnection.tableExists"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PostgresConnection.tableExists" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </dd></dl> <dl class="function"> <dt id="sqlobject.postgres.pgconnection.PsycoBinaryConverter"> <code class="descclassname">sqlobject.postgres.pgconnection.</code><code class="descname">PsycoBinaryConverter</code><span class="sig-paren">(</span><em>value</em>, <em>db</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#PsycoBinaryConverter"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.PsycoBinaryConverter" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="function"> <dt id="sqlobject.postgres.pgconnection.escape_bytea"> <code class="descclassname">sqlobject.postgres.pgconnection.</code><code class="descname">escape_bytea</code><span class="sig-paren">(</span><em>value</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/postgres/pgconnection.html#escape_bytea"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.postgres.pgconnection.escape_bytea" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </div> </div> </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="nav-item nav-item-0"><a href="../index.html">SQLObject 3.7.0 documentation</a> »</li> </ul> </div> <div class="footer" role="contentinfo"> © Copyright 2004-2018, Ian Bicking and contributors. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.7.4. </div> </body> </html>