crypt(table.field) ? - Mailing list pgsql-general

i know "password" can be used in creating/altering user
information (as used via GRANT and REVOKE) but is there any
facility within postgres to CRYPT() a value?

    create rule new_folk as on insert to view_folk do instead
        insert into folk_table
            (created,login,password)
            values
            (current_timestamp,new.login,CRYPT(new.password))
            ;

or must this be done (say, in perl) before postgres sees it?

--
will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!