Re: data encryption

lcarson(at)ucsd(dot)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