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-----
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. |