Skip site navigation (1) Skip section navigation (2)

Re: I'm very confused.

From: Brant Fitzsimmons <brant(at)bfcomputerconsulting(dot)com>
To: Jasbinder Singh Bali <jsbali(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: I'm very confused.
Date: 2007-01-17 08:06:57
Message-ID: 45ADD921.3030800@bfcomputerconsulting.com (view raw or flat)
Thread:
Lists: pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jasbinder Singh Bali wrote:
> Please attach a snippet of your python script and lets see what are
>  you doing there. That might make things easy. Jas

Here is the entire test script:

#!/usr/bin/python

# import pgdb module
import pgdb

# connect to the db
db = pgdb.connect(host="localhost", database="test", user="postgres",
password="**********")

# instantiate cursor
cursor = db.cursor()

# insert 10 records
for x in range(10):
    cursor.execute("INSERT INTO users (username, firstname, lastname,
email, age) VALUES ('brant', 'Brant', 'Fitzsimmons',
'brant(at)bfcomputerconsulting(dot)com', 31)")

# retrieve the data
cursor.execute("SELECT * FROM users")
result = cursor.fetchall()

# print data to the screen
for line in result:
    print line
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFrdkhDpzwx2t8E5gRAiPpAJ0QHGmawHqiZWy2NKTUbWncrpWWGgCdF3oS
IjwEPfhuuvIthx4U8MsoyHA=
=lvc7
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2007-01-17 11:25:01
Subject: Re: I'm very confused.
Previous:From: Brant FitzsimmonsDate: 2007-01-17 08:06:38
Subject: Re: I'm very confused.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group