Inserting Data Into a PostgreSQL Database

From Al Lukaszewski, former About.com Guide

The module we will use for this tutorial is 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 any of your fields require a date or time, you will also want to import the datetime module, which comes standard with Python.

import datetime

Previous

• Psycopg: Install and Import
• Python to PostgreSQL: Open Sesame
• Mark Your Place in PostgreSQL With Python
• Separating PostgreSQL Form and Python Function
• Python, PostgreSQL, and the 'C' Word
• Define the Parameters
• Put it All Together And Call It

Next