Re: field with Password

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.
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  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