From postgres bytea to file (a PDF for example)

pgbytea2file.py

# Execute select in pgAdmin
# write result to file
"""
select encode(my_bin_field,'base64')
from my_schema.my_table
where id=123;
"""
# Remove column name from generated file

import base64 
recovered = base64.decodestring(open("my_base64_file","r").read())
f = open("my_bin_file.pdf", "wb")
f.write(recovered)
f.close()

Thanks for the piece of code! For me, changing to binary reading mode ('rb') made it work:

recovered = base64.decodestring(open("my_base64_file","rb").read())

Thanks for sharing this code, but I found some errors like

AttributeError: module 'base64' has no attribute 'decodestring'

Now I made changes like decodestring to decodebytes,

recovered = base64.decodebytes(open("my_base64_file","rb").read())
it's working with the above line of code.

#python3.8 #base64