Re: data encryption

lcarson@ucsd.edu wrote:
> Does anyone have experience using the feature in PG 8.4 (maybe earlier
> versions too??) to store specific columns in an encrypted format?  We are
> gathering sensitive data for medical studies and want to use Postgresql,
> however, we need to insure that the data is secure to satisfy federal
> HIPAA regulations.  One way to do that would be to store some or all of it
> in an encrypted format.

See:
  http://www.postgresql.org/docs/8.4/interactive/pgcrypto.html

But the tricky part is the key management more so than the encryption.

Joe