You could use md5() described in:
http://www.postgresql.org/docs/current/static/functions-string.htmlRgds.
g.-
On 3/9/06, Kevin Crenshaw <kcrenshaw@viscient.com> wrote:I have a table that stores usernames and passwords and I want to encrypt the passwords before they are stored in the database. Will postgresql do this for me, or do I have to do the encryption on the client side? Could you please point me to some instructions on how to accomplish this.
Thanks for your help,
kevin
--
/"\ ASCII Ribbon Campaign .
\ / - NO HTML/RTF in e-mail .
X - NO Word docs in e-mail .
/ \ -----------------------------------------------------------------