python and Postgresq

Andy dixon ajd at
Mon Nov 23 11:36:26 CET 2009

"Diez B. Roggisch" <deets at> wrote in message 
news:7mv62nF3hp171U1 at
> Andy dixon wrote:
>> Hi,
>> Does anyone have a link to, or can provide an example script for using
>> python-pgsql ( or if someone 
>> can
>> recommend an alternative, that would be fantastic.
> I'd recommend psycopg2.
> This is an introduction:
> But google yields tons more. And make sure you read the python db api 2.0
> spec, this should give you the general idea on how to work with Python &
> RDBMS, which is nicely abstracted away from the actual database.
> Diez

Amazing. Works like a charm!


I used the code (stripping out certain bits) if anyone else may find it 

#!/usr/bin/env python
import psycopg

def main():
        connection = psycopg.connect('host=<HOST> dbname=<DB> user=<USER> 
        mark = connection.cursor()
        query='SELECT * FROM table'
        record = mark.fetchall()
        for i in record:
                print i

if __name__ == '__main__':

More information about the Python-list mailing list