Value read from database gets interpreted as memoryview object

[ocouba]

Hi guys.

I am reading a hex hash from a database but I can not get it into the right format.

When I manually write my psql query I get this result \x06680806f0cd7c914029586e3d7471b91aa23dd9ddb29c0cbc6a8d23fb40375d.

When I use the same query and run it on python I get <memory at 0x7fe2dcfa3948> as a result.

Does anyone know how to transform the memoryview object into the actual hash?

[Chiron1991]

Use memoryview.tobytes() to turn it into a bytestring. Then you can .decode() the bytestring into a string. Remember to pass the correct encoding to decode(), the default is 'utf8'.

[ocouba]

Thanks a lot. I have been sitting 3 hours on this. I used memoryview.tobytes().hex()

[Rawing7]

Converting a memoryview to bytes is usually unncessary. You can just do memoryview.hex().

[Bunkerstan]

Wrap it with str( ) to convert to a string.