Thank you, Joe.
Your solution provided below works great. Much better/simpler than my
original approach. You rock!
-Michael
_
From: Joe Conway [mailto:[EMAIL PROTECTED]
Sent: Mon 4/11/2005 3:26 PM
To: Moran.Michael
Cc: PostgreSQL
Subject: Re: [SQL] PGCrypto: Realworld scenario and
Moran.Michael wrote:
My initial attack plan was to do the following:
1. Call decrypt() with the old-passphrase to decrypt each table's existing
data.
2. Temporarily store the decrypted data in temp tables.
3. Delete all rows of encrypted data from the original tables -- thereby
clearing the table
Hello all,
I'm looking for advice on real-world PGCrypto usage.
I understand how to programmatically encrypt/decrypt data with PGCrypto --
no problem.
My question is:
What is the best way to update massive amounts of *existing* encrypted data
with a new encryption passphrase, assuming you k
