1. Home
  2. SQL
  3. Postgresql

Summary

In this chapter, we've shown you the Python DB-API (version 2.0). There are at least three implementations of the PostgreSQL/DB-API interface; we've used the PyGreSQL implementation because that it is the one you are most likely to have (it's distributed with PostgreSQL).

As we mentioned at the start of this chapter, you can also use the PyGreSQL interface without using the DB-API wrapper. PyGreSQL is a nifty toolkit, but the DB class offers some nice features.

You've made it through all the chapters devoted to PostgreSQL programming. In the next section, we'll be examining the administrative tasks involved in creating and maintaining a PostgreSQL environment.



    		Part I: General PostgreSQL Use
    		Part II: Programming with PostgreSQL
    		Chapter 5. Introduction to PostgreSQL Programming
    		Chapter 6. Extending PostgreSQL
    		Chapter 7. PL/pgSQL
    		Chapter 8. The PostgreSQL C API - libpq
    		Chapter 9. A Simpler C API - libpgeasy
    		Chapter 10. The PostgreSQL C++ API - libpq++
    		Chapter 11. Embedding SQL Commands in C Programs - ecpg
    		Chapter 12. Using PostgreSQL from an ODBC Client Application
    		Chapter 13. Using PostgreSQL from a Java Client Application
    		Chapter 14. Using PostgreSQL with Perl
    		Chapter 15. Using PostgreSQL with PHP
    		Chapter 16. Using PostgreSQL with Tcl and Tcl/Tk
    		Chapter 17. Using PostgreSQL with Python
    		Python/PostgreSQL Interface Architecture
    		Prerequisites
    		Client 1 - Connecting to the Server
    		Client 2 - Adding Error Checking
    		Client 3 - Query Processing
    		Client 4 - An Interactive Command Processor
    		Summary
    		Part III: PostgreSQL Administration