How to insert a binary blob in PostgreSQL?

Question

PostgreSQL

I write like this:

UPDATE "REQUESTS" SET shape= pg_read_file('123.jpg')::bytea WHERE request_id>0;

An error is thrown:

ERROR: invalid byte sequence for encoding "UTF8": 0xff

How to be?

Answer 1

www.postgresql.org/docs/9.5/static/functions-admin.html
In short, why are you trying to read the binary with a text function, and do not take the regular pg_read_binary_file, which just reads bytea.