crypt(table.field) ?

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!

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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