From: | will trillich <will(at)serensoft(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | crypt(table.field) ? |
Date: | 2001-04-26 14:15:45 |
Message-ID: | 20010426091544.C12147@serensoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
From | Date | Subject | |
---|---|---|---|
Next Message | will trillich | 2001-04-26 14:27:43 | Re: Seral field value after INSERT ! |
Previous Message | will trillich | 2001-04-26 14:12:41 | Re: last comma inside "CREATE TABLE ()" statements |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-04-26 14:26:38 | Re: refusing connections based on load ... |
Previous Message | Vince Vielhaber | 2001-04-26 14:00:42 | Re: [GENERAL] Re: Hardcopy docs available |