[taffer]

Have you had a look at the bytea[1] type? It allows you to store binary objects up to 1GB and it's dumped transparently just like a string.

[1] https://www.postgresql.org/docs/current/datatype-binary.html