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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
