Executing an insert into postgres using psycopg2

Question

I'm trying to insert data using psycopg2 into postgres. Here is the psuedo code I have. It seems to run without error but when I use navicat to check, it doesn't seem to update in the database. I did restart navicat to be sure.

conn = psycopg2.connect("dbname=dbname user=username password = ****  host='localhost'")
cur = conn.cursor()

Here I tried a straight execute and a mogrify.

cur.mogrify("""INSERT INTO database (date, id) VALUES (now(), %s );""" % (user,))
cur.execute

I also tried this instead of the mogrify

cur.execute("""INSERT INTO database (date, id) VALUES (now(), %s );""" % (user,))

I can query a select statement but insert doesn't seem to be working.

Did you execute commit after insert?

Em L
– Em L

2016-08-27 05:14:41 +00:00
Commented Aug 27, 2016 at 5:14 — Em L
– Em L, Commented Aug 27, 2016 at 5:14

Alireza Afzal Aghaei · Accepted Answer · 2016-08-27 05:12:40Z

4

commit the data?

conn.commit()

answered Aug 27, 2016 at 5:12

Alireza Afzal Aghaei

1,23511 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Julien Over a year ago

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - From Review

Alireza Afzal Aghaei Over a year ago

@JulienBernu i thought its only possible answer. sorry:)

user2723240 Over a year ago

Just for clarification, after executing you still need to commit the data using the function conn.commit()

Collectives™ on Stack Overflow

Executing an insert into postgres using psycopg2

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related