On Wed, Dec 24, 2003 at 11:47:53AM -0500, [EMAIL PROTECTED] wrote: > > Is there any function on postgresql that allows to encrypt data when > making an Insert statment?
What kind of encryption are you looking for? MD5 is a one-way hash: you can't decrypt the hash to get back the original plaintext. If that's what you need (e.g., for storing passwords), then you could use the md5() function that's part of the the standard distribution since version 7.4. http://www.postgresql.org/docs/current/static/functions-string.html For older versions of PostgreSQL or for additional encryption functions, see the code in contrib/pgcrypto. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
