On 28 January 2011 02:06, David Patricola <david.patricola@jefferson.edu> wrote:
> What I have to do is store multiple fields encrypted from user input, them
> decrypt them for retrieval to the browser. Is there a preferred way to do
> this?
Try creating a column with type "bytea" and store the results of the
encrypt() in there. Then use that column with decrypt(). (Or alter
the type of your existing "thenotes" column from varchar to bytea.)
See also:
http://www.postgresql.org/docs/9.0/static/datatype-binary.html
Note: I've never used pgcrypt.
--
Michael Wood <esiotrot@gmail.com>