[GENERAL] using types for encrypting fields

2006-03-29 Thread Tobias Herp
Hi, I have the need to encrypt some columns in some tables. With Postgres 7.4, using a tablespace on an encrypted partition is not an option, right? Thus, my idea is: - put the encryption/decryption key in a temporary table - create types for each type of data which must be encrypted (enc_numeri

[GENERAL] using types for encrypting fields

2006-03-28 Thread Tobias Herp
Hi, I have the need to encrypt some columns in some tables. With Postgres 7.4, using a tablespace on an encrypted partition is not an option, right? Furthermore, the content would be contained unencrypted in any database dump. Thus, my idea is: - put the encryption/decryption key in a temporary