Re: crypt(table.field) ?

From: Marko Kreen <marko(at)l-t(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: crypt(table.field) ?
Date: 2001-04-26 16:13:59
Message-ID: 20010426181359.A29269@l-t.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, Apr 26, 2001 at 09:15:45AM -0500, will trillich wrote:
> 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?

At the moment no. You should patch your PostgreSQL source for
that. There is a patch in techdocs site which imports system
crypt to SQL level and there is my pgcrypto package which does
this and more...

http://www.l-t.ee/marko/pgsql/pgcrypto-0.3.tar.gz

--
marko

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-26 16:16:49 Re: error compiling 7.1 on Solaris 8 x86 (long)
Previous Message Justin Clift 2001-04-26 16:12:27 Re: Re: Need for newbie friendly docs (was Newbie struggling...)

Browse pgsql-hackers by date

  From Date Subject
Next Message Barnes, Sandy (Sandra) 2001-04-26 16:36:51 applications hang when calling 'vacuum'
Previous Message Jan Wieck 2001-04-26 15:58:38 Re: RI oddness