We do all of our encryption in the middleware:
1) translate our data which requires encryption into an XML string
2) compress + encrypt, yielding byte [].
3) Store byte [] as a bytea column.
The resulting byte arrays are relatively small in our case (1 -> 3K),
so bytea has
Hi fellows, I need to encrypt fields of data type
LO (LO is included in the contrib section of PostgreSQL) and I don’t know
if pgcrypto is the way to do that or there is another way. If anyone knows the
answer of my problem or know an alternative way to do this, I’ll appreciate
you can sha