how to append a bytes in a Postgres bytea array

Question

I have an account table database which stores username, email, password and images[]. And what I want to do that every time they share a picture the picture bytes should append in images type bytea[]. I used several methods but always ends up with an error what is the solution?


bytea = []

my_cursor = mydb.cursor()

with open(os.path.join('image\\Image.png'), 'rb') as file:
    image = file.read()
    #bytea.append(image)

insert_info = f"SELECT array_append(images, {image}) WHERE id = 7"


my_cursor.execute(insert_info)
mydb.commit()

The error

psycopg2.errors.SyntaxError: syntax error at or near "("
LINE 1: SELECT account array_append(images, b'\x89PNG\r\n\x1a\n\x00\...

You're SELECTing not INSERTing or UPDATEing; This >>>insert_info = f"SELECT array_append(images, {image}) WHERE id = 7" should be this >>>insert_info = f"UPDATE array_append(images, {image}) WHERE id = 7" — 3kstc
– 3kstc, Commented Sep 7, 2021 at 1:03
Its hits me with an error psycopg2.errors.SyntaxError: syntax error at or near "(" — Salman_al_03
– Salman_al_03, Commented Sep 12, 2021 at 22:02

Mohammad Bhbouh · Accepted Answer · 2021-09-09 11:26:42Z

1

you must write select rather than insert :

bytea = []

my_cursor = mydb.cursor()

with open(os.path.join('image\\Image.png'), 'rb') as file:
    image = file.read()
    bytea.append(image)

insert_info = f"insert array_append(images, {image}) WHERE id = 7"


my_cursor.execute(insert_info)
mydb.commit()

answered Sep 9, 2021 at 11:26

Mohammad Bhbouh

1139 bronze badges

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

1 Comment

Salman_al_03 Over a year ago

I used the script above but still here is the error

psycopg2.errors.SyntaxError: syntax error at or near "array_append" LINE 1: INSERT array_append(images, 'b'\x89PNG\r\n\x1a\n\x00\x00\x00...

Collectives™ on Stack Overflow

how to append a bytes in a Postgres bytea array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related