use md5 function in a trigger when insert data or see this link
http://www.postgresql.org/docs/8.3/static/pgcrypto.html --- On Mon, 7/28/08, Chris Preston <[EMAIL PROTECTED]> wrote: > From: Chris Preston <[EMAIL PROTECTED]> > Subject: [SQL] Encrytion in postgres field in table > To: pgsql-sql@postgresql.org > Date: Monday, July 28, 2008, 1:25 PM > How do I setup a password table that I only want to encrypt > 1 field > "password" -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
