Re: field with Password - Mailing list pgsql-general

From A. Kretschmer
Subject Re: field with Password
Date
Msg-id 20090204102642.GB23072@a-kretschmer.de
Whole thread Raw
In response to field with Password  (Iñigo Barandiaran <ibarandiaran@vicomtech.org>)
List pgsql-general
In response to Iñigo Barandiaran :
> Hi.
>
>
> I would like to create a new table where one of the field would be a
> user password. Is there any data type for supporting this functionality?
> Something like Password DataType. I've taken a look of the available
> data types in PgAdmin Application and there is nothing similar to this.

You can store the md5-Hash instead the plaintext password.
(char(32) and a length-check)


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: field with Password
Next
From: Iñigo Barandiaran
Date:
Subject: Re: field with Password