Re: field with Password - Mailing list pgsql-general

From John R Pierce
Subject Re: field with Password
Date
Msg-id 49896D0A.6030206@hogranch.com
Whole thread Raw
In response to field with Password  (Iñigo Barandiaran <ibarandiaran@vicomtech.org>)
Responses Re: field with Password  (Iñigo Barandiaran <ibarandiaran@vicomtech.org>)
List pgsql-general
Iñigo Barandiaran wrote:
> 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.

most commonly, passwords are stored as hashes, such as md5,  rather than
plaintext.    'text' would be as suitable for this as anything, or
bytea, if you want to store the hashes in binary.




pgsql-general by date:

Previous
From: Thomas Markus
Date:
Subject: Re: field with Password
Next
From: "A. Kretschmer"
Date:
Subject: Re: field with Password