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.




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to