Encrypt data type LO
Hi fellows, I need to encrypt fields of data type LO (LO is included in the
contrib section of PostgreSQL) and I dont 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, Ill appreciate you can share this with
me.
Regards.
Ing. Carlos Alberto Piña Uribe
Consultoría y Desarrollo
KEBIR Infraestructura Tecnológica
alberto.pina@kebir.com.mx
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 seemed to suit us just fine.
----
James Robinson
Socialserve.com