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

Re: I'm very confused.

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: pgsql-novice(at)postgresql(dot)org
Cc: Brant Fitzsimmons <brant(at)bfcomputerconsulting(dot)com>, Jasbinder Singh Bali <jsbali(at)gmail(dot)com>
Subject: Re: I'm very confused.
Date: 2007-01-17 11:25:01
Message-ID: 200701170625.01471.sdavis2@mail.nih.gov (view raw or flat)
Thread:
Lists: pgsql-novice
On Wednesday 17 January 2007 03:06, Brant Fitzsimmons wrote:
> 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)")

Put in a db.commit() statement here.  Does that fix your problem?

> # retrieve the data
> cursor.execute("SELECT * FROM users")
> result = cursor.fetchall()
>
> # print data to the screen
> for line in result:
>     print line
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

In response to

Responses

pgsql-novice by date

Next:From: Jasbinder Singh BaliDate: 2007-01-17 12:32:56
Subject: Re: I'm very confused.
Previous:From: Brant FitzsimmonsDate: 2007-01-17 08:06:57
Subject: Re: I'm very confused.

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