how to insert bytes data into a bytea datatype column?

[AshwinRaam]

I want to insert my image or audio file that i receive from fastapi endpoint as bytes data. I tried to insert it into using execute but it failed. psycopg2 has something like psycopg2.Binary() to convert python bytes data into the bytea format accepted by the postgresql. Can anyone give me an example to do the same with asyncpg, i really want to use asyncpg but this is error is making me to shift to psycopg2.

[elprans]

Simply pass your Python bytes object as an argument. bytes aren't special in asyncpg.

bin = b'123'
await conn.execute('INSERT INTO bintable (byteavalue) VALUES ($1)', bin)