Re: field with Password

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.