| 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: | Whole Thread | Raw Message | 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 |