Insert an array in postgresql

Question

I use python to connect to my postgresql database. I parse a XML fill to populate my base, so I have an array[] of values for one line to insert. I have something like this:

cur.execute("""INSERT INTO ACTIVITYDESC VALUES (%s,%s,%s,%s,%s)""",(value[0],value[1],value[2],value[3],value[4]))

There is a way to make this more simple like: ?

cur.execute("""INSERT INTO ACTIVITYDESC VALUES (%s)""",(value))

Thank for your help

Possible duplicate of Python MySQLdb cursor.execute() insert with varying number of values — Ozgur Vatansever
– Ozgur Vatansever, Commented Apr 25, 2017 at 13:57
@ozgur Not a duplicate of that question. Many differences including the DB — Clodoaldo Neto
– Clodoaldo Neto, Commented Apr 25, 2017 at 14:49
I have try this but it's doesn't work in my case, but thank you. — Fedour
– Fedour, Commented Apr 26, 2017 at 7:10

Clodoaldo Neto · Accepted Answer · 2017-04-25 14:46:13Z

0

Turn the list into a tuple:

t = tuple(value)
cur.execute("""INSERT INTO ACTIVITYDESC VALUES %s""",(t,))

answered Apr 25, 2017 at 14:46

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

Collectives™ on Stack Overflow

Insert an array in postgresql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related