Python Postgres how to insert

Question

try:
    conn = psycopg2.connect("dbname='test1' user='postgres' host='localhost' password='123'")
    cur = conn.cursor()
    cur.execute("""INSERT INTO product_info (product_name) VALUES (%s)""", 'xxx')
except:
    print "error happens"

The above is my code snippet, I have no trouble connecting to the database, but I have some problem inserting the value into it.

I execute the same query in postgres and it works, so i think it's a syntax problem.

Can someone show me what is the right way to do insertion?

still get the same error

user2628641
– user2628641

2016-03-09 15:43:42 +00:00
Commented Mar 9, 2016 at 15:43 — user2628641
– user2628641, Commented Mar 9, 2016 at 15:43

Clodoaldo Neto · Accepted Answer · 2016-03-09 17:23:18Z

1

cur.execute("""
    insert into product_info (product_name) VALUES (%s)
""", ('xxx',))
conn.commit()

Notice that the value is passed to the method wrapped in an iterable.

answered Mar 9, 2016 at 17:23

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

Collectives™ on Stack Overflow

Python Postgres how to insert

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related