Python PostgreSQL API for BYTEA

[badaboum84]

I have to migrate a current PostgreSQL database to MSSQL. For doing this task I uses Python to create script for doing this task.

Now, I want to extract the data from the current PostgreSQL database, but I need a API. I decided to go with PSYCOPG2, but it seem to have a problem with the BYTEA datatype. I use these lines of code :

self.cursor.execute('SELECT * FROM electronicassembly WHERE id_pk = 2')        
list = self.cursor.fetchall()
print psycopg2.Binary(str(list[0][19]))

But it print me value like \\000\\0JEBF. I know that is suppose to be octal format, but character like JEBF is not "octal" and sometime (for other binary data) it is punctuaction character, like ';@ that are showed. So, do I miss something.... ??

Or, do you know another Python API that can handle BYTEA correctly ? Because, for MSSQL the binary for a BULK INSERT as to be in hexadecimal format.

Thanks

P-S : Sorry for my english, it is not my first language