From: | Iñigo Barandiaran <ibarandiaran(at)vicomtech(dot)org> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: field with Password |
Date: | 2009-02-04 10:36:33 |
Message-ID: | 49896FB1.3090103@vicomtech.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for your answers. Sorry for the questions but I'm new to Postgre :)
The problem with a plain text password is that a user can see it by
looking at the user table.
Both suggest to use MD5. How can i use it? Any link, example about this
would be very appreciated.
Thanks in advance!
> 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.
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2009-02-04 10:46:40 | Re: field with Password |
Previous Message | A. Kretschmer | 2009-02-04 10:26:42 | Re: field with Password |