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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2007-01-17 11:25:01 Re: I'm very confused.
Previous Message Brant Fitzsimmons 2007-01-17 08:06:38 Re: I'm very confused.