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