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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
