Reading from a PostgreSQL Database With Python

The module we will use for this tutorial is again psycopg. It is available from http://www.initd.org/projects/psycopg1. So download it and install it using the directions that come with the package.

Once it is installed, you can import it like any other module:

# libs for database interface
import psycopg

If you would like your program to take input from the keyboard, you will also want to import the sys module. In this tutorial, I will illustrate how every major part of the SQL statement can be input from the keyboard. So, let your import line read as follows:

import sys, psycopg

Index: Reading from a PostgreSQL Database With Python

1. Introduction
2. Psycopg and Python: Perfect Together
3. Receiving Command Line Arguments for the PostgreSQL Statement - I
4. Receiving Command Line Arguments for the PostgreSQL Statement - II
5. Connecting to PostgreSQL Through Psycopg
6. Forming the PostgreSQL SELECT Statement
7. Executing the SELECT Statement Through Psycopg
8. A Container for the Results
9. Finishing and Executing the Program