Thanks Michael, I'll check that module.<br /><br /><br /><b><i>Michael Fuhr <mike@fuhr.org></i></b>
wrote:<blockquoteclass="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">
OnThu, May 18, 2006 at 04:21:19AM -0700, Thusitha Kodikara wrote:<br />> Are there any encryption functions that can
beused in<br />> SQL inserts and selects directly? For example like<br />> "select
encryptin_function('test_to_be_encrypted'),........"<br /><br />See the contrib/pgcrypto module. It has functions like
digest()<br/>for making SHA1, MD5, and other digests; hmac() for making Hashed<br />Message Authentication Codes; and
encrypt()/encrypt_iv()and<br />decrypt()/decrypt_iv() for doing encryption and decryption. Since<br />8.1 pgcrypto also
hasfunctions for doing OpenPGP symmetric and<br />public-key encryption.<br /><br />-- <br />Michael Fuhr<br /><br
/>---------------------------(endof broadcast)---------------------------<br />TIP 5: don't forget to increase your
freespace map settings<br /></blockquote><br />