Re: [HACKERS] Encrypt data type LO

2004-11-24 Thread James Robinson
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

[HACKERS] Encrypt data type LO

2004-11-24 Thread Alberto Piña
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