psycopg2: how to update multidimensional array with row

Question

I'm struggling to update multidimensional arrays in my postgres table with new rows. In psql:

CREATE TABLE list_of_arrays (my_array int[]);
INSERT INTO list_of_arrays VALUES ('{{1, 2}}');
UPDATE list_of_arrays SET my_array = my_array || '{{3, 4}}';
SELECT * FROM list_of_arrays;

yields the array:

{{1,2},{3,4}}

In psycopg2, however the update step fails:

row1 = [[1, 2]]
row2 = [[3, 4]]
cur.execute("INSERT INTO list_of_arrays VALUES (%s);", (row1,))
cur.execute("UPDATE TABLE list_of_arrays SET my_array = my_array || %s;",(row2,))

returns:

psycopg2.ProgrammingError: syntax error at or near "TABLE" LINE 1:
UPDATE TABLE list_of_arrays SET my_array = my_array || ARRAY

erthalion · Accepted Answer · 2016-02-12 16:00:45Z

1

I believe it should be like this:

cur.execute("UPDATE list_of_arrays SET my_array = my_array || %s;",(row2,))

without a keyword TABLE

answered Feb 12, 2016 at 16:00

erthalion

3,2923 gold badges25 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

psycopg2: how to update multidimensional array with row

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