test_cockroach_binary.py

import psycopg2

create_table = '''
create table if not exists test_bt (
v BYTEA
);'''

binary = b'\xff\xd8\xff\xe0\x00\x10'

conn = psycopg2.connect('postgresql://root@localhost:26257/test?sslmode=disable')

with conn as conn, conn.cursor() as c:
    c.execute(create_table)
    c.execute('insert into test_bt (v) values (%s)', (binary, ))

    c.execute('select * from test_bt')
    rv, = c.fetchone()
    rv = bytes(rv)
    print('got', repr(rv), 'expected', repr(binary))
    c.execute('drop table test_bt')
    
    assert rv == binary