Popular recipes tagged "postgres" but not "sql"http://code.activestate.com/recipes/tags/postgres-sql/2014-02-21T09:17:23-08:00ActiveState Code RecipesGlobal database configuration and context aware connection pool extention for psycopg2 (Python)
2010-02-26T02:57:49-08:00Valentine Gogichashvilihttp://code.activestate.com/recipes/users/4172185/http://code.activestate.com/recipes/577072-global-database-configuration-and-context-aware-co/
<p style="color: grey">
Python
recipe 577072
by <a href="/recipes/users/4172185/">Valentine Gogichashvili</a>
(<a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/postgres/">postgres</a>).
Revision 2.
</p>
<p>This extention makes it possible to hold a global configuration of all needed database, and access this databases using a special context aware named connection pools. The context can help to automate transaction commits and rollbacks and return special connection cursors in the context.
See module and class docs for more information.</p>
Dump PostgreSQL db schema to text (Python)
2014-02-21T09:17:23-08:00Michal Niklashttp://code.activestate.com/recipes/users/186902/http://code.activestate.com/recipes/576557-dump-postgresql-db-schema-to-text/
<p style="color: grey">
Python
recipe 576557
by <a href="/recipes/users/186902/">Michal Niklas</a>
(<a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/postgres/">postgres</a>, <a href="/recipes/tags/postgresql/">postgresql</a>, <a href="/recipes/tags/schema/">schema</a>).
Revision 7.
</p>
<p>With PostgreSQL there is:</p>
<pre class="prettyprint"><code>pg_dump --schema_only
</code></pre>
<p>but I wanted to compare my PostgreSQL and Oracle database schema dumped by:
<a href="http://code.activestate.com/recipes/576534/">http://code.activestate.com/recipes/576534/</a></p>